MSSQL Server does not recognize this syntax, but it does accept select distinct substring(username, 1, 1)
Ian A. Harding Programmer/Analyst II Tacoma-Pierce County Health Department (253) 798-3549 [EMAIL PROTECTED] >>> Bruno Wolff III <[EMAIL PROTECTED]> 10/18/02 10:13AM >>> On Fri, Oct 18, 2002 at 12:45:56 -0400, Wei Weng <[EMAIL PROTECTED]> wrote: > 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? Looking through the documentation on string functions would be helpful. An example solution is: select distinct substring(username from 1 for 1) from users; ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
