Trim and UCase in a query

[Moragtao]

Hello all,

I have a query where I need to run both the trim and the ucase functions on, but I can't seem to figure out how to do it without getting errors. Is there even a way to run 2 different functions on the same column in a query?

Also, is it possible to run either the trim or the ucase function on a column in a query and keep the same column name? Or do I have to change it to something different?

[CJ_London]

try:

trimmedString:trim(ucase(myfield))

where myfield is the name of the field you want to modify

if this is not what you want, provide the code that did not work and some examples of before and after

Also, is it possible to run either the trim or the ucase function on a column in a query and keep the same column name? Or do I have to change it to something different?

you have to change it otherwise sql will not know which column you are referring to. You can use the caption property to use the same name (that is what it is for) if you are only concerned about how the column will be headed

[Minty]

You can normally do both at the same time. If your text field was called PoorlyFormated , something like

NewLovelyText : UCase(Trim([PoorlyFormated]))

In a query should work.