Hi,
I have basically created a load of generic usernames to give out with default "firstname", "Surname", "display name" & "email@mydomain.com" fields pre-filled.
What I want to do is some kind of IF statement to say that if
SELECT FirstName
FROM Users
WHERE UserID = $(UsedID)
= 'FirstName'
then display a message to say "Please update you profile, Click Here"
But I'm not sure how to do this... Probably very basic, but would appreciate if anyone could point in the right direction.
Many thanks
Pete