Finding ", " in a field using an expression 1

[jimdevon]

I cannot get this to work. IIF([wholenm] = "," , 1, 2)
also tried IIf([wholenm]= *","*, 1, 2) no luck always get "2".
The field wholenm has this format (Smith, John), problem is some people at this company just entered (John Smith). I need to use instring and lenght to pull first name regardless of which method they used. Thanks in advance. Jimdevon

 

[lespaul]

what you are checking for is if the name = ",", don't you really want to see if it's in wholename?


iif(InStr(',', [wholename]), 1, 2)

leslie