[SQL] Is there anyway to...

Hello all, Is there an existing mechanism is postgresql that can automatically increment/decrement on a daily basis w/out user interaction? The use case I'm considering is where a student is in some type of contract with an instructor of some sort, and that contract puts a time limit on the s

Re: [SQL] Is there anyway to do this?

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, 200

Re: [SQL] Is there anyway to do this?

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 | cha

[SQL] Is there anyway to do this?

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