I have need to run a script over certain records in a table for records that all begin with the same string (I am resetting passwords for temporary accounts).
What I have at the moment is:
While User.UserName LIKE 'TEMP%'
In the example I might have user accounts like TEMP1, TEMP2, TEMP3 etc
The problem seems to be in the second line.