Ive got two tables:
tbl_agents and tbl_clients
~ In tbl_agents, the dashes are embedded in the data (to distinguish if it
s SS or TIN)
~ In tbl_clients, there are no dashes (only SS numbers for the clients)
I need to create a search tool that will search these tables and enable the
users to type the nine digits without entering dashes. How to do this?!
Kind of stumped and a newbie here, all help is greatly appreciated.
Thanks,
Mike Dooley