listFirst, listRest, using "." as the delimiter? That's what I'd use
in CF at least. If you want to do it in the DB, you'd have to do
something like left(value, find(".", value) - 1) for the pounds, and
then the reverse for the pence.
cheers,
barneyb
On 11/8/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I've got a number in one of my fields which has a decimal point. I
> want to pull everything from the left of the point so I can use that
> value separately for a drop down box for the £ value (pound sterling)
> and to the right for the pence select box. I'm just wondering what
> the best way of finding the digits before the decimal place and after
> it.
>
> Any help would be great, thanks,
>
> Saturday
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223611
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
