Skip to Content
0
Former Member
May 05, 2009 at 02:21 PM

Search for table entries with mixed case(Upper and Lower Case)

41 Views

Hi All,

I have a table with entries like

Test

TEST1

I have a search help for this filed,

1)If i give t* or T* it gives me both the records

This works fine

2) If i give te* or TE* or tE* or Te* i get only TEST1, but i want both to be displayed

Does any have any idea as to how to do this

Thanks