i have a text field named 'zip' in an access database that contains a zipcode such as "60101-0452".
the user enters a 5 digit zipcode in a form (i.e Form.password)
i want to be able to compare the first 5 digits of the 'zip' field to what the user entered.
<cfquery name="qname" datasource="dsname">
SELECT * FROM table where username = '#Form.username#' AND zip = '#Form.password#'