assuming you are comparing text, you may want to make it case sensitive
battk
02/08/2019, 9:12 PM
as far as netsuite search is concerned, A and a are the same
s
shubs
02/08/2019, 9:16 PM
@battk what section is not-case sensitive in your opinion? the search?
b
battk
02/08/2019, 9:17 PM
yes
s
shubs
02/08/2019, 9:19 PM
Any suggestions on how to do that? I see some stuff online using INSTR. In our current case, however, we don’t necessarily care for case sensitivity.
b
battk
02/08/2019, 9:21 PM
from memory, when i had to do this, I just got all the search results and made sure that the field value matches the search result value before declaring it unique