var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Server Query Syntax Help
Following is my one of the field of Server table and it s data (SQL Server 2000 Desktop Ver.)
R/C ISU IND
CP FLANGE R/C
FAB. KICK LINE
COAT R/C LINE
To get the specific data of this WORK_DESC from table, I used following query which results fine.
SELECT RpoMstId, RPO_No, Start_Date, WORK_DESC
WHERE (WORK_DESC = N'R/C')
What would be the syntax if I need to represent the data that has ‘R/C’ prefix or suffix in the data field? (anywhere in the data column)
With kind regards,
You want "Like" with some wildcards. More info in BOL.
Probably this would be the fastest respond to the thread in the whole forum.
I tried LIKE (Like n'*R/C*') but did not work out.
Can u please clarify how to use it?
Had you looked in BOL as recommended, you'd have realized you used the wrong wildcard character.
As am new bee to Server I did not understand BOL. What do mean by?
Last edited by rudra; 11-06-06 at 01:41.
Success is the ability to go from one failure to another with no loss of enthusiasm.
- Sir Winston Churchill
Books Online, the primary reference tool of any SQL Server user. It should have been included with your SQL Server installation.