I'd convert all the data to decimal values and convert back to fractions if you have to for display purposes.
YOu could do this with CF if your SQL is a tad weak like mine: 1) Select all records with the fractions 2) Loop over the results 3) Do the math...use ListGetAt(column,"1","/") for numerator and ListGetAt(column,"2","/") for the denominator....then <cfset result = numerator/denominator> 4) Update record with new decimal value NOTE: You may need to add a new blank column with a float datatype to put the new values in....then once all updating is done...toast the old column and change the name of the one you put the new data in to the name of the original column. I know this is a tad clumsy...but it will get ya there. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 12:56 PM Subject: I sent this before and got no response...maybe someone can help? > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
