Richard Korts
asked on
MySQL
Is there a way to force the first letter of a field in a MySQL table to be upper case?
So when the INSERT (or UPDATE) is done, if the first letter is lower case, it makes it upper case?
Thanks
So when the INSERT (or UPDATE) is done, if the first letter is lower case, it makes it upper case?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks a lot for the points (NOT) for giving you the MySQL structure you asked for. I'm sure Sharath appreciates getting all the points for incorporating my answer.
I expect a split of points here as yodercm has provided you the actual logic and I just gave you a suggestion on how to implement that logic.
yodercm - you can request moderator for split of points. I am happy for that.
yodercm - you can request moderator for split of points. I am happy for that.
ASKER
OK, I'm fine with that. How do I "request moderator for split of points"?
ASKER
To yodercm & Sharath_123:
I requested a moderator to split the points.
rkorts
I requested a moderator to split the points.
rkorts
ASKER
I am using php strings on a web server to update & insert data.
I'm not clear on where I put this.
In the table definition?
Thanks