>I usual do a wild card search for a string of characters with a
>SELECT - SQL statement. I always put a space in front of the string to
>filter out unwanted results. If the word or string I'm looking for is
>preceded by carriage return it will not pick it up the record. How can I
>adjust my SELECT statement to account for the carriage return?
>
>This is how I look for it now: WHERE descriptiveField LIKE "% StringValue%"
>
>Thanks!
You can filter unwanted leftmost character using:
Select .... Where Left(descriptiveField,1)<>chr(13)
Edward Pikman
Independent Consultant