- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-14-2009 10:06 AM
(4376 views)
if index(name,'Novo Distribution')
Can we make the search not case sensitive?
Like if the argument-2 here 'Novo Distribution' can be in any case.
Can we make the search not case sensitive?
Like if the argument-2 here 'Novo Distribution' can be in any case.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
if index(upcase(name),upcase('Novo Distribution'))
will do that.
will do that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Also, consider the FIND function which is case-blind by default.
Scott Barry
SBBWorks, Inc.
Scott Barry
SBBWorks, Inc.