I have an email variable that I would like to check to see if it contains an uppercase character. In MySQL i was able to use this in my where statement:
where ascii(substring(billto_name,2,1)) >= 65
and ascii(substring(billto_name,2,1)) <= 90
How do I use the Case function to check to see if there is an uppercase character in an email address?
Thanks!
Bill
where ascii(substring(billto_name,2,1)) >= 65
and ascii(substring(billto_name,2,1)) <= 90
How do I use the Case function to check to see if there is an uppercase character in an email address?
Thanks!
Bill
