[SQL] Is there anyway to do this?

[Wei Weng]

I have a table 

               Table "Users"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
 userid    | character varying(40)  | not null
 username  | character varying(64)  | 

I want to get all the distinct first character of all usernames. And do
it in a way that is the most portable to MS SQL server.

Is there anyway?

Thanks

-- 
Wei Weng
Network Software Engineer
KenCast Inc.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])