Hello SQL Experts,
I have a table with account #'s ( Example : 20-200-300-4000)
I am using parameter in my query to search for the all account number or a single account, but they would also like to be able to search by segments ... If possible I would like for when the search text box appears on the screen it would look something like this
__-___-___-____ so the user can use mouse or cursor to move to a particular segment and type in, for instance 200 in the second segment as in the example above and all accounts with 200 in that segment is returned or 4000 in the last segment and all accounts with 4000 in the last segment is returned.
similar search box example.
Any help on how to do the SQL search that will return all accounts with the entered segment will be appreciated.