we have 3 fields that i am trying to Consolidate into one. i have created a custom view in SQl to consolidate all 3 of them into one view. however when i program the SQL Lookup it is created with LIKE.
So if the client lookup up the code 298 it returns 2981, 29811 2982, 00002981, 'LIC 00002981' etc..... The view contains some 500,000 records.
Is there any way to change it so it only returns exact matches?