Daniel, a while ago you gave me this information on passing output parameters to SQL 7.
I have a stored procedure that I have created and I want it to return to me a number when it is found.

Here is the test call I created:

lcSSfno = '8726273'
lcFind = " "
lnExec = SQLEXEC(lnConn,"Exec sp_seek_ssfno ?lcssfNo,?@lcFind")

Here is the stored procedure:

CREATE PROCEDURE sp_seek_ssfno

@ssfno CHAR(10),
@lnFound CHAR(10) OUTPUT

AS


SELECT @lnFound = (SELECT ssfno FROM tranhdr WHERE ssfno = @ssfno)
The problem is I am only getting one character returned.

Ex: The number captured into lnFound = '8726273'
The return value I get is '8'. What am I doing wrong, not to get the entire number?