Just a division problem, really. This should get you started...
DECLARE @NUM DECIMAL(10)
DECLARE @DENOM DECIMAL(10)
DECLARE @INCHFIELD VARCHAR(10)
DECLARE @RESULT DECIMAL(10,4)
-- OUTPUT YOUR FRACTION HERE --
SET @INCHFIELD = '3/4'
SELECT @NUM = SUBSTRING(@INCHFIELD, 1, CHARINDEX('/', @INCHFIELD) - 1),
@DENOM = SUBSTRING(@INCHFIELD, CHARINDEX('/', @INCHFIELD) +
1,LEN(@INCHFIELD)),
@RESULT = @NUM/@DENOM
SELECT @NUM, @DENOM, @RESULT
M
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 3:57 PM
To: CF-Talk
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
