Upper Case Conversion

[JJman]

What is the syntax for an update query to convert something to upper case, i.e., convert br4579215 to BR4579215? I've tried Update To: >Left([fieldname],2), but it doesn't like the >, even though that is the correct symbol for upper case.

Thanks!

 

[hneal98]

ucase(br4579215)

 

[MakeItSo]

Hi JJMan,

UCase(Mid([fieldname],3)

should be what you're looking for.

Cheers,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[MakeItSo]

OOoops, forgot a closing bracket:
UCase(Mid([fieldname],3))

 

[warthog72]

You could just use UCASE(field) - its not going to convert your numbers. No need to parse it out.

 

[JJman]

Thanks All,

Works great!