select * from emp where id='-----'
ID name dob Test testing 27-06-2013 test xxxxx 30-02-2013
COLLATE Latin1_General_CS_AS
Quote:SQL SELECT col FROM table WHERE col COLLATE Latin1_General_CS_AS = 'value'
SELECT col FROM table WHERE col COLLATE Latin1_General_CS_AS = 'value'
StrComp
Quote:SQL WHERE StrComp('myText1', 'MYTeXt1', 0) = 0 Documentation[^]
WHERE StrComp('myText1', 'MYTeXt1', 0) = 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)