Skip to Content
0
Former Member
Oct 05, 2010 at 04:57 PM

Uppercase / Lowercase

215 Views

i am sure there is a real quick solution to this.

In record selection i have

{

{hostname_txt.Hostname} = lowercase({SRMHOST.HOSTNAME})

}

which returns all the lowercase matches for hostname

i then have to run the same report and change record slection to

{

{hostname_txt.Hostname} = uppercase({SRMHOST.HOSTNAME})

}

to return all upper case host names

the input file hostname_txt,Hostname contains both upper/lowercase names

Options - Datbase server is case insenstitive is checked

What should my record selection formula be to return both upper and lower case matches ?

Thanks in advance.