SQL update is lowercase

Comersus Version: 0
Database type: Access
Frequency: Permanent issue


I used the SQL Tool to update message # 173 to say 'First Name' instead of simply 'Name'… but it results in "first name" being entered into the DB. Without downloading the db and putting it back up there, how can I update it to be capitalized?

here's the SQL statement I used

UPDATE screenMessages
SET screenMessage = 'First Name'
WHERE idScreenMessage = 173

Thanks,
Mark

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *