In my db I've got a varchar column called 'width'. It has values like 3/4" or 5/8", etc.
I'd like to write a where clause in a SQL query that does something like this: WHERE 0=0 AND (WIDTH BETWEEN #FORM.Width1# AND #FORM.Width2#) [i.e. -- (AND (0.75 BETWEEN 0.5 AND 1))] What do I need to do to make this work? Covert? Cast? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
