Hi all
The following works in 7.2.1 -
1. select count(*) from SysUsersCompanies where UserRowId = 3 ;
2. select substring('NY',(select count(*) from SysUsersCompanies where UserRowId = 3)+1,1) ;
The first select returns either 1 or 0
The second one uses the result in a more complex expression, and returns either 'Y' or 'N'
In 7.3.2, the first select behaves the same, but the second one returns NULL.
Any advice will be appreciated.
Frank Millman