hi,
are you aware of the UPPER and LOWER function in ANSI SQL? you said you need to use your sp, but can you change it slightly to force the returned locationtype to lower case.
in regards to the insertion of the T char to indicate UCT or not....could you use a wildcard on your message content assertion? you could wildcard the position between the date and the time time. or instead of message content assertion perhaps you could use a regex assertion instead? although this may be a little less rigorous assertion than you actually need.
this is reminding me of something i did before......i'm sure i had the same timezone indicator problem. i will look through my work tosee if i sorted it out.
cheers
richie
