iif with a like : data mining problem (2000 SP3)

Topic

New Reply

I have a text field that has characters and numbers, a value of 3 indicates high risk, a sample text could be “noise (3), solvents (2)”, I want to create an new risk variable that would attribute a “high risk” to the risk variable if a “3” is present in the text, otherwise a value of medium risk should be attributed.

Iif (text variable = like *3*, “high risk”; “medium risk “)

Reply | Quote

Replies

You must enclose all literal string values in quotes, and enclose field names in square brackets:

IIf([Text Field] Like "*3*","high risk","medium risk")

Reply | Quote

I am embarassed

Reply | Quote