ON SUBSTRING (ERR.FIRSTNAME,1,3) = SUBSTRING (DEM.FIRSTNAME,1,3) --NOTE- IT WILL ONLY TRY TO MATCH 1ST 3 CHARACTER ON BOTH TABLES AND THAT WILL BE THE SAME --NOTE- IT WILL HELP BCZ PEOPLES NAME'S ...

This action first finds the substrings that start with start and end with end in the given string string. It then extracts the substring between the start and end substrings from the result of the ...

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no ...