Steve Jones  ,

Is it applicable now??

Beacuse I got some points for the old question

Yes ur right kangaroo 

But the problem is what will happen for a string which already has two '

Say

for Dinesh''Asanka

replace(Dinesh''Asanka) = Dinesh''''Asanka

My...

RLoski 

I think u have to change the date/time fields as well.

Great!

But for QOD's better to impose dead line. beacuse u will be getting the answer in the newsletter on folowing day and u will be able to answer that question on...

This will give u some idea of doing that

http://www.sqlservercentral.com/columnists/ccubley/findinganddeletingduplicatedata_printversion.asp

Search 'duplicate'  in http://www.sqlservercentral.com

Use folowing function to convert ' to ''

on Error GoTo eh:

Dim strName() As String

Dim i As Integer

strName = Split(txtName, "'")

Dim obj As Variant

txtName = ""

i = 0

For Each obj In...

If I understand ur question I think ur looking for something like this?

Select * from orders where shipregion is not null

want to add more tuning into it!!

better if u replace

 (shipdate > '20030101' AND shipdate < '20031231') to year(shipdate ) = 2003

and

 (shipdate > '20020101' AND shipdate < '20021231') to...

http://www.geocities.com/sqlserverexamples/date5.htm

Goood site too

Declare @Fdaynm datetime -- First Day of Next Month

-- Set the @Fday to the first day of the next month

-- By adding a month to the...

mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"

Great, That is ok with me

Thank you guys

Ok,

But my problem is with getting next number of identity column

Thankx for the answer

Actually I'm doing this via VB. Is there any way of doing it

Thankx for the answer. That will be my last option If I didn't get any other solutions.

Ur solution is ok.

But problem existing when there...

Thankx for the information