February 10, 2006 at 12:25 am
WHERE (A._LHAND LIKE '%' ||B.COL1||'%' OR A._RHAND LIKE '%' ||B.COL1||'%')
what is ' || ' for in this where clause?
Thanks in advance...
-kv
February 10, 2006 at 12:50 am
should be string concat. But this does not looks like T-SQL maybe PL/SQL ?
February 10, 2006 at 12:55 am
Looks like the data is from or to a '||' delimited file or similar.
As written I don't think it's a valid statement.
Could it be that it's supposed to be LIKE '%||' + B.COL1 + '||%' ....?
In other languages '||' can mean OR, but not in T-SQL.
Is this code from SQL Server or somewhere else?
/Kenneth
February 10, 2006 at 3:17 am
It looks like the psuedo syntax out of a reporting tool.
Cognos queries sort-of look like SQL but aren't really.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply