Email Parser

HI,
is there a way to grab a number from an SQL database, put it in a variable and then add 1 (so I get the next number to write back into the database)?

I can grab the number with a select....where statement but how to proceed from there. Tried the static fields but they give me "number +1" literately.

thanks!

You mean something like this?

Select coalesce(Max(erecid),0)+1 as wrecid from emlfxa7.temlmsg

wrecid is static field...

@vanMark,

yes that is what I'm looking for! Thanks!