So Simple yet.....

[brad2610]

This one is killing me because it is so simple but I am having erious brain blockage....

Basically looking to write a script / calculation that does the following.

If (Field name) starts with "UL" then (Client) = "Ultra" If not then "Unknown"

Here is my current entry that is not working correctly.

If (Field name=Left ("UL"; 2) ; "Ultra" ; "Unknown" )

Someone please save my brain from the fog it is in.

thanks

Brad

[comment]

Case ( Left ( FieldName ; 2 ) = "UL" ; "Ultra" ; "Unknown" )