J John Vinson Aug 19, 2004 #2 Is there a way to convert a text column in a query to uppercase? Thanks Click to expand... Yes; if you just want to *display* it as upper case set its Format property to If you want to permanently update all the values in the table to upper case, run an Update query updating Field1 to UCase([Field1]) (Don't forget the square brackets or you'll find that all the records now contain FIELD1 - back up your database first!!)
Is there a way to convert a text column in a query to uppercase? Thanks Click to expand... Yes; if you just want to *display* it as upper case set its Format property to If you want to permanently update all the values in the table to upper case, run an Update query updating Field1 to UCase([Field1]) (Don't forget the square brackets or you'll find that all the records now contain FIELD1 - back up your database first!!)
G Guest Aug 19, 2004 #3 So you mean make it appear in uppercase in the query? Something like Ucase(fieldname) If you want to change it in the table then you need an update query. maybe something like Update tablename set fieldname = ucase(fieldname) where fieldname is not null (e-mail address removed)
So you mean make it appear in uppercase in the query? Something like Ucase(fieldname) If you want to change it in the table then you need an update query. maybe something like Update tablename set fieldname = ucase(fieldname) where fieldname is not null (e-mail address removed)
J John Spencer (MVP) Aug 19, 2004 #4 Field: MakeUpper: UCase([MyField]) In SQL statement SELECT UCase([MyField]) as MakeUpper FROM TableName
Field: MakeUpper: UCase([MyField]) In SQL statement SELECT UCase([MyField]) as MakeUpper FROM TableName
