Totally depends on what you're doing (select, update, insert) and where
your data is coming from.
But something like:
SELECT * FROM AddressBook
WHERE PhoneNumber = '(#areacode#) #exchange#-#suffix#'
Or maybe
SELECT '(' + areacode + ') ' + exchange + '-' + suffix AS PhoneNumber
FROM AddressBook WHERE LastName = 'Doe'
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 7:21 AM
To: CF-Talk
Subject: OT:SQL quicky
How do I format a phone number (###) ###-#### within my cf sql
statement? My backend is sql 2000. Thanks in advance.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
