I'm trying to do a select
to find on a char field that has a single quote but getting
errors. This is what I'm doing: Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD' The text I'm trying to find is BERLETT'S ROAD If I do the same thing but have double quotes in the string instead of single quotes this works. -- Christine Penner Ingenious Software 250-352-9495 chris@xxxxxx |