I don't see anything wrong with your code Have you tried to change compatibility levels?

Yes  I am ,

It takes time to get used to the "new thinking" but once you get the gist of it you'll find it fun

Ok if you what to have alook at a dynamic version here it is !!

declare @str varchar(8000)

select @str = 'SELECT

     CASE(B.FUNCTSTR)

         WHEN ''A'' THEN ''Smart Scheduler''

         WHEN ''B'' THEN...

Like I suspected 0D in Hex is 13 in decimal therefore you have Char(13) embeded in the field !!!

so you can :

select len(replace(store, char(13),''))

and Enjoy

Like I said before:

Wouldn't it be the same if you report the data the other way around?

Month  TimeClock Schedule People Editor  ......

February  12345     2345       456678 ...

March      12345     2345       456678 ..

April        ...

I believe you have char(10) + Char(13) attached at the end of those.

Can you post what does

select cast(store as varbinary(20))

returns

Can you post the definition of the table TEMP ?

Have a look:

http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html

SELECT

     CASE(B.FUNCTSTR)

         WHEN 'A' THEN 'Smart Scheduler'

         WHEN 'B' THEN 'People Editor'

         WHEN 'C' THEN 'DCM'

         WHEN 'E' THEN 'Time Card Editor'

         WHEN 'F' THEN 'Mobile Time'

         WHEN 'G'...

UPDATE  t2

           SET[COL1] = i.[1]

From Table2 t2 join  inserted i

     on  i.ID = t2.id

where i.[1] IS NOT NULL

There is no order concept in an SQL Server Table.

You need to specify order by on your query to make sure the effects are repeatable!!!

and make sure you specify the outer table on the select list !!!!

select clients.* from clients left join risk on clients.id=risk.id

where risk.id is null

Nancy,

Your solution is fine. Just for the fun of it

is this what you were talking about

create procedure change_status_traces @status int as

begin

declare @str varchar(8000)

select  @str =  Isnull(@str,'') + ' execute...