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
 

Reply via email to