>How can I re-write this select statement to work in an SPT statement?
>
>"Select AllT(fname)+' '+AllT(lname),emadd From usrtbl Where At(AllT(ldeptno),AllT(dept_over)) > 0"

It depends on what back end you're using.