Not in Select Statement

Question

Hi!

I need to specify in the select statement that the USER_1 field is not equal to 'STD'.

I tried first putting it in the where clause but get an error stating that the multipart statement could not be identified.

How can I specify this in the following select statement?

MAX(LEFT(ISNULL(USER_1,''),50)) AS CODE

Answer 1

0

It looks like you have two different questions. The first, how to ensure USER_1 is not equal to 'STD' you do this:

SELECT tn.*
FROM dbo.TableName AS tn
WHERE tn.USER_1 != 'STD'

Obviously I have substituted a table where yours would go.

You can't filter data in the SELECT clause. That is what the WHERE clause is for. If you're getting an error that the name doesn't exist, it suggests that you may have a problem in the code elsewhere.

The second question is around the MAX statement. You will have to make that a part of a GROUP BY query for it to work.

answered Aug 07 '12 at 12:11 PM

Grant Fritchey ♦♦
61.9k ● 12 ● 19 ● 66

(comments are locked)

Not in Select Statement

Follow this question

Related Questions