cancel
Showing results for 
Search instead for 
Did you mean: 

IF on a Query

Former Member
0 Kudos

Hi.

In Access I can determinate a field as:

CodeOK: IIf([Code] Like 'GR*';[RDR1].ItemCode;[Code])

In SBO 2004 ... how can I do it ?

regards.

Accepted Solutions (1)

Accepted Solutions (1)

former_member184566
Active Contributor
0 Kudos

Hi

In sbo and sql used in enterprise. The "iif" is "if" and * is %.

Hope this helps

Answers (0)