Re: SQL or CF to do an alphabetical list

[Kevin . Marshall]

Joseph,

If you do a

SELECT Right(textfield,(Len(textfield)-1)) AS name
FROM .....

You can select all but the first character of a field value.

Alternatively you can

SELECT Left(textfield, 1) AS name
FROM ...

and just get the first character.

Hope that's what you had in mind.

Kevin

--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500



                                                                                       
                            
                    "Joseph                                                            
                            
                    Higgins"             To:     Fusebox <[EMAIL PROTECTED]>   
                            
                    <higgjose@isu        cc:                                           
                            
                    .edu>                Subject:     SQL or CF to do an alphabetical 
list                         
                                                                                       
                            
                    11/11/00                                                           
                            
                    05:15 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    fusebox                                                            
                            
                                                                                       
                            
                                                                                       
                            





Does anyone know of an ACCESS sql function that will strip off the first =
character of a string so that you can group output alphabetically?





------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.