I’m pulling data from an SQL database, with an input of part number which is in the format of X-NNNN-NNNN sometimes with a suffix of -NN or -XXX, and i want to ignore that suffix.
My SQL querie is as follows:
where [Part_Number] LIKE $Part_Number$+’%’
Part_Number in the database is always X-NNNN-NNNN and the input might be things such as:
In my understanding the ‘+’%’ wildcard should work, but its not. Only the first case above works, the other 2 return ‘null’