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!