> select cast((max(substring(test.test from 6 for 4))) as integer) + 1 > FROM test where max(substring(test.test from 11 for 2));
This where clause is just returning a number but not comparing it to anything. Normally it would be something like WHERE test.test = max(substring(test.test from 11 for 2)). That is the reason for the error message you are seeing. I don't quite get how you are expecting to return 4 from 0004 instead of 3 from 0003 based on the statement above. Mike > > > List below is a better idea of what my table looks like and the result > I need. > > PROJ-0004-05 > > PROJ-0001-06 > > PROJ-0002-06 > > PROJ-0003-06 > > > > When I run my select statement I want to return the number 4. The > idea is that I need the next highest number in the middle but take in > consideration that the highest trailing numbers take president. > > > > There error I get is this ERROR: argument of WHERE must be type > boolean, not type text > > > > ______________________________________________________________________ > Be one of the first to try Windows Live Mail. Windows Live Mail. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
