Either of these should work, depends on your preference for placement of aliases:

SELECT

MyField02= CASE

WHEN (Right(MyField,2)*1)=7 THEN '999'

WHEN (Right(MyField,2)*1)7 THEN '888'

ELSE NULL

END

FROM

MyTable

SELECT

CASE

WHEN (Right(MyField,2)*1)=7 THEN '999'

WHEN (Right(MyField,2)*1)7...

Since you don't have any wildcards defined in the one using NOT LIKE, I would think that the optimzer would evaluate them the same, but as Gail said, "Try it...

Let me see if I understand the problem. You have an AD group, let's call it ProdDBAs, which has sysadmin rights on your SQL Servers and the concern is...

So are trying to update the data in the table or trying to output a column named myfield02 in a result set?

You certainly can remove them all, but I don't know that you should. You can manage your SQL Server so that you just use SQL Logins or just use...

Forgot to comment on the Amazon issue. Amazon put themselves into a tough spot by allowing these books to be uploaded and then came across as heavy-handed in their...

I have no idea how many books I read in a year, probably anywhere from 20-50. I should start keeping a list. I have to admit that I...

You don't need the MyField = in the THEN portion you just need the value.

SELECT

CASE WHEN (Right(MyField,2)*1)=7 THEN '999' END,

CASE WHEN (Right(MyField,2)*1)7 THEN '888' END

FROM MyTable

Jan Van der Eecken (7/24/2009)

---

Just consulted my 13 year old son, an avid reader (actually all three of my children are avid readers, they go through books quicker than I...

Mr. ".", I had the first 2 books and just checked my library and they are no longer with me. You can get them on Amazon though. I...

The Mad Scientist Club, fantastic! I had those books and forgot. Will be checking to see if the local library has them for my kids! Another good...

What is vdn? I don't see it in the select list anywhere.

I think you'll be better off by moving the filtering on vdn to the WHERE clause, and I...

I loved King's earlier stuff and I loved the Gunslinger series (actually it's called The Dark Tower) until the ending. The way he ended it really sucked. My...

Can you post the table definition (Create table) and some sample data? Maybe just the "1000" rows. I'm thinking it may have something to do with the way...

Can you post your table definition? What data type is starttime?