On 09/07/2010 02:04 PM, Christine Penner wrote:
I have a character field in a table that contains either a file name or a full path and file name. I need to pick out the ones that have no full path. I do this by looking for no \. This is what I am doing:select MM_PATH_FILE from MULTI_MEDIA Where MM_PATH_FILE NOT ILIKE '%\\%' -this gives me all records no matter what has a \ or not select MM_PATH_FILE from MULTI_MEDIA Where MM_PATH_FILE NOT ILIKE '%\%' -this gives me nothing again no matter what has a \ or not I even tried thisselect MM_PATH_FILE from MULTI_MEDIA Where position('\' in MM_PATH_FILE)=0-this gives me an error Any other suggestions?
... like E'%\\\\%' Cheers, Steve -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
