Hi, [SQL Query Question] I have a Table where some data is entered by the user. Before it's submitted to the DB I need to run a Query on another table based on what the user has entered, and I need to lookup the first 2 digits of their Post Code against a listing in another table. For example: Poster A enters "DT6 4RT" as their Post Code. I need to lookup the first 2 digits, i.e. "DT". How can this be done? Thanks in advance, Will -- Lukrative Media Ltd - Berkshire, UK ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
