Sriram Ramamoorthy,

your query doesn't work

Server: Msg 170, Level 15, State 1, Line 15

Line 15: Incorrect syntax near ','.

This is what i want.

SAMPLE

apple avenue w

melon road e

watermelon circle n

banana durian crossing s

apple1 avenue w

melon1 road e

watermelon1 circle n

banana1 durian crossing s

RESULT

apple INTERNET w

melon INTERNET  e

watermelon INTERNET  n

banana durian...

Jeff Moden   what is the problem with sysobjects

declare @townID varchar(25),

     @sql varchar(1000)

set @townID = '''00003'''

if exists (select * from sysobjects where xtype= 'u' and name = @townID)

print 'exists'

else

print 'don''t exists'

its printing 'dont exists'. it should print exists...

i think its 2627

so it will be like

if @@error = 2627

print 'error'

how can i write the code to catch the error?

is it somehting like

if @@error <> 0

print 'error'

get visustin

sql to flowchart