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.