In Select statement you can specify column heading, whereas in print statment you cannot.

Select 'Critical point passed' 'column1'

print 'Critical point passed'

Hi,

You can store the formats with the format id's in a table. Then you can match the input parameter with that table to get the format id and use dynamic...

Hi,

create table #Like_Test( Col1 varchar(5) )

go

insert #Like_Test values('_Cus')

insert #Like_Test values('Cus_')

insert #Like_Test values('C_us')

insert #Like_Test values('Cus')

insert #Like_Test values('Cu_s')

--select * from #Like_Test

select * from #Like_Test where Col1 Like '%Cu_%'

This query produces...

Hi,

Nice articles.

I have tried with the steps given in that articles. Messeges are queued, but not sent.

Sent status is in "unsent" in sysmail_allitems table.

Thanks & Regards,

Krish.