yes, SP....use them for everything, even the shittiest SQL query..... -----Original Message----- From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question
> Use an SP. Stored procedure my arse! SELECT DISTINCT LEFT(Surname,1) AS MyAlpha FROM User ORDER BY LEFT(Surname,1) Taz -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
