Hello comunity


I have build this code to return my accountbank number:

Text to msel textmerge noshow
SELECT BankAccount =
Stuff((SELECT ', ' + Cast(bl.noconta as varchar)
FROM bl INNER JOIN us
ON Rtrim(us.area) = Rtrim(bl.u_area)
WHERE
userno = 1 AND bl.u_area IS not null

For XML PATH ('')),1,1,'')
Endtext

If u_sqlexec(msel,[Cursorbanknr])
Local mybanknr as String
Mybanknr = '(' + Alltrim(mybanknr) + ')'
Else
msg(msel)
Endif

If i run the query in SSMS query the value return is : 16, 35 that is correct.

But if i put a messagebox on variable Mybanknr , the value is : () , also i select the cursor Cursorbanknr and make a browse, this one is empty.

someone could give me some help!

Many thanks
LS



If i run this query on SQL server they return theses values : 16,35