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? Convert? Cast? I don't know how to make SQL convert 7/8" into 0.875. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
