In a query I want to examine a string. I want to learn if the string's first position is "1".
So, I want to say if this string's first character is "1" then do something.
I have used either iif( Left([thevariable],1) = "1",
and I have used iif( [thevariable] like "1*",
Which of the two statements run faster OR is there another form my comparison can take?