I have a query that looks up part numbers. It is as follows in the code snippet below. Dashes need to be ignored (ie: if 'RRAL-1972' is entered into the search box, nothing is found..., yet RRAL1972 can be found. How can I strip out the characters like the dash, or a pound sign? Thanks in advance!!
<cfquery name="getCR" datasource="">
SELECT * FROM tbl_cr
WHERE cr_them LIKE '%#form.cr_them#%'