[rt-devel] Case insensitive search.

Jason Slagle raistlin at tacorp.net
Mon Jun 4 10:47:55 EDT 2001


Would be a big plus on some of the searches (Esp subject and content).

lower() is a SQL92 function I believe so you could make the SQL server do
it.

where lower(subject) like lower('%value%');

Jason

-- 
Jason Slagle - CCNP - CCDP
Network Administrator - Toledo Internet Access - Toledo Ohio
- raistlin at tacorp.net - jslagle at toledolink.com - WHOIS JS10172
/"\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
\ /   ASCII Ribbon Campaign  . If dreams are like movies then memories
 X  - NO HTML/RTF in e-mail  .   are films about ghosts..
/ \ - NO Word docs in e-mail .     - Adam Duritz - Counting Crows






More information about the Rt-devel mailing list