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 ...