Find \ in text
От | Christine Penner |
---|---|
Тема | Find \ in text |
Дата | |
Msg-id | 19740413172944.A459334623C222BF@edmwaa03.telusplanet.net обсуждение исходный текст |
Ответы |
Re: Find \ in text
Re: Find \ in text Re: Find \ in text |
Список | pgsql-general |
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 this select MM_PATH_FILE from MULTI_MEDIA Where position('\' in MM_PATH_FILE)=0 -this gives me an error Any other suggestions? Christine Penner Ingenious Software 250-352-9495 christine@ingenioussoftware.com
В списке pgsql-general по дате отправления: