[SQL] Is there anyway to...

2006-11-06 Thread louis gonzales
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

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

2002-10-18 Thread Bruno Wolff III
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