Posted by: sumansuman May 13, 2008
Login in to Rate this Post:
0
?
Part I
If you want to do case sensitive search and if your database is installed on case in-sensitive mode you can do following. I am assuming your language setting is on English mode.
Just a sample OK...
Create table #test (f_name varchar (50))
insert into #test values ('Pranita')
insert into #test values ('pranita')
insert into #test values ('PranitA')
If you do
select f_name from #test where f_name = ‘Pranita’; you will get all values Pranita,pranita and PranitA
Now try this one
select f_name from #test where f_name = 'Pranita' COLLATE SQL_Latin1_General_CP1_CS_AS
Now you will get only value Pranita not pranita and PranitaA.
Continue ...
Last edited: 13-May-08 02:21 PM