Re: Index function

Quartz | Level 8

Index function

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.

2 REPLIES 2

Rhodochrosite | Level 12

Posted 10-14-2009 10:49 AM (4212 views) | In reply to SASPhile

if index(upcase(name),upcase('Novo Distribution'))

will do that.

Lapis Lazuli | Level 10

Posted 10-14-2009 06:05 PM (4212 views) | In reply to Doc_Duke

Also, consider the FIND function which is case-blind by default.

Scott Barry
SBBWorks, Inc.