Link to home
Start Free TrialLog in
Avatar of ethanjohnsons
ethanjohnsons

asked on

select when upper only

select lname, fname, Jobtitle, dept
bla....
where ...

I want to have the result returned when only all of lname, fname, Jobtitle, dept are in upper case.
any ideas?
SOLUTION
Avatar of VirusMinus
VirusMinus
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Peerapol
Mr_Peerapol

If your server is case-sensive, you can just use lname = UPPER(lname).
However, by default, it's case-insensitive, so you will need to do something like my above answer.
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
nice one Mr_Peerapol & acperkins :)
Avatar of ethanjohnsons

ASKER

Wonderful!