Oops .... the above post didnt decode the characters properly...it was NOT "?" which i posted....

Hi another input......i m tryin the following....

EXEC xp_sendmail 'a@b.c', N'Dear ?t gi?i'

sorry mate pblm with backspace in my keyboard

SELECT CASE WHEN CLIENTBOXNUMBER IN ('0096028', '0096076')

                    THEN  '0096064'

                     ELSE

            END  as 'ColumnName'

FROM    TableName

rharma...was spot on...but just wanna make things perfect...

SELECT CASE WHEN CLIENTBOXNUMBER IN ('0096028', '0096076')

                    THEN  '0096064'

hey mate...wat i had posted will do a perfect insensitive search...

but will affect urs...

sorry should have read ur description clearly...

i ve now read...but...

hey thatz quite simple...

just follow this way...

where upper(fac) = upper(watever here)

or

where lower(fac) = lower(watever here)

hey thatz quite simple...

just follow this way...

where upper(fac) = upper(watever here)

or

where lower(fac) = lower(watever here)

create table #tempo (id int, generated bit)

insert into #tempo (id, generated)

select distinct id, 0 from [YOUR_TABLE]

create table #temp1 (id1 int, date1 datetime)

declare @id int

while exists (select * from #tempo where...

 Hi...i dont think there is a need for RIGHT OUTER JOIN here,

 thatz the cause for the 3x rows.

 Rather use INNER JOIN...

Update table1

Set table1.YZBX01 = table2.YZBX01,

table1.YZBX02 = table2.YZBX02,

table1.YZBX03 = table2.YZBX03,

table1.YZBX04 =...

try this ....

SELECT

a1.account,

a1.disease_prog,

a1.confirm_flag,

a1.consent_flag,

a1.opt_out_reason_code

FROM ah_member_flags a1 WITH (nolock)

inner join ah_member_flags a2 on a1.account = a2.account

    and a1.company = a2.company

    and a1.disease_prog = a2.disease_prog

WHERE a1.confirm_flag = 'y'

and  a1.consent_flag =...

Hi...Do you mean this...

select ''','''

..run this is Query analyser..

hope this helps

Riyaz

hey Also...Ask your network admin watz the email id that SQL Server uses....try sending an email to that id...

find is that reaching SQL inbox using xp_readmail.

Perfect !!!...in that case the fault is ur SQL Server couldnt connect to ur Microsoft Exchange server...its the matter of some rule settings with your networks...You ll have to...

Group by col1, col2, col3 is the best option....

but watz ur fourth column...wat shd it return...

can you be more specific...for a specific answer.

Thanks

Riyaz

Group by col1, col2, col3 is the best option....

but watz ur fourth column...wat shd it return...

can you be more specific...for a specific answer.

Thanks

Riyaz