<CFSET lookup = Left(Form.PosterNumber, 2)> ...
SELECT .....
WHERE PostCode LIKE '#lookup#%'
At 9:52 PM +0100 5/13/2000, WL wrote:
>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_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
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.
