Insert that data in a working table with a varchar(20) column.

Then run this : SELECT * FROM dbo.TempTable WHERE ColName LIKE '%[^0-9]%'

It will scan for any non-number characters.  If no rows...

My comment was a little more intended for Farrell , !

We've all been there. Thanx for the contribution!

NP.  That's why I find it usefull to use the check syntax button before posting a solution .

The homemade kind .

It copies the system tables and displays the data about the same way SSMS does.  It also seconds as a documenting tool...

It's with the same attitude that I learned SQL server... and got to that post count .

UPDATE tblProject SET

     tblProject.status = 'I'

FROM  dbo.tblProject

   INNER JOIN tblTemp_Project ON( tblProject.project = tblTemp_Project.project)

WHERE tblTemp_Project.status = 'I'

How will the users feel about this decision?

Oh I C. Well that's becoming a moo point now since we don't have a failing code from the poster.  There's not much more we can say at this point!

Lol.. simple solution to that.  Ask a coworker to IM you the characters... or use copy paste from your adress book .

Recheck my code.  There are 10 ends in a row in the first query and it works.

Then I add another nested case (11th) and it won't even compile.

From a totally unbiased position.  I think a free pass to PASS 2007 would be in order .

, thanx for letting us know...  Might save a few jobs around here !

Do you know if there is a way to install enterprise over standard and overwrite the previous instance, but keeping all the system databases intact and keeping the user databases?

How about this :

SELECT 

CASE WHEN 0 = 1 THEN 1 ELSE

CASE WHEN 1 = 2 THEN 2 ELSE

CASE WHEN 2 = 3 THEN 3 ELSE