Hi all,
I would like to perform a query that finds the first characters from a string.
For example:
Having Smitherson in the string that I can enter 'Sm' or 'SMITH' or 'S' and include the record.that start with those character without limit of characters entered. If I enter S include all records that start with 'S' but if I enter SM that also should include all records that start with 'SM'
Unlike instr function that include the characters found in any place of the string I would like to search only if the character are in front of the string.
I also tried the equal = sign but that find the exact match for the string.
What function can I use?
Thanks for the help!
Javier