IF Question

[#1]

Hi,

has someone an idea how I can handle something like this:

if(category = '1' OR category '2', 'all', if(category='2', 'only 2')) AS categoryclass

thanks

Aloah

[#2]

Please key in your question with some explanations to what you need..

[brenner_martina]

Hello,

What about that Condition:

If(category='2',If(category = '1', 'all', 'only 2')) AS categoryclass

[#4]

In your data can a single record have more than a single value the field category? Understanding the potential values of the field will help suggest the correct syntax of your conditional statement.

/emb

[brenner_martina]

Pardon, there is the bracket wrong:

If(category='2',If(category = '1', 'all'), 'only 2') AS categoryclass