if statements in queries?

[PreacherUK]

Just wondered if there was a way to do something like the following (Which is possible in MS Access):


FieldnameAlias: if([Fieldname]<0,0)

Which would produce a 0 for any value under 0.

Is the way to accomplish this to priduce a copy of the data and run an update statement against it?

Cheers

 

[dbomrrsm]

CASE FIELDNAME < 0 THEN 0

DBomrrsm

 

[PreacherUK]

How can I work this into a view?

It says the query designer does not support the case function.

 

[despierto]

Use SQL Query Analyzer to write and test your query, then use the "create view" SQL to create the view.