On 09/07/10 2:44 PM, Steve Crawford wrote:
Any other suggestions?
... like E'%%'
and, for extra fun, if that SQL statement is a constant string in a C or
similar programming language, you may well need to double up those \'s
again so that SQL sees them as the C/C++/etc parser itself d
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 Wh
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 Wh
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 Wher
