RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case

2002-01-24 Thread Bill Grover
> Sent: Wednesday, January 23, 2002 11:48 PM > To: CF-Talk > Subject: RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. > sentence case > > > Whoops, looks like I read that wrong. > > http://www.cflib.org/library.cfm?ID=1 > > There's

RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case

2002-01-23 Thread C. Hatton Humphrey
The easiest way would be: #UCase(Left(FIRSTNAME, 1))##LCase(Right(Firstname, Evaluate(Len(Firstname) - 1)))# Or a variance thereof. Hatton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 11:47 PM To: CF-Talk Subject: How to make '

RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case

2002-01-23 Thread Steve Oliver
Whoops, looks like I read that wrong. http://www.cflib.org/library.cfm?ID=1 There's quite a few UDF's for string manipulation there. Namely one called CapFirst __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: [EMAIL PR

RE: How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case

2002-01-23 Thread Steve Oliver
You mean getting firstname from a database and sending it in an email? That's pretty simple, something like this: SELECT firstname FROM users Where id = 1 Dear #getUser.firstname#, Blah blah blah __ steve oliver cresco technologies, inc. http://www.crescotech.com -