Hi,
I have a procedure where the following line of code is included:

strTSQL = "EXEC sp_gettitles " & lngParam

However, in the above lngParam is a long value.
How will the code change if the above parameter is a string one
i.e. strParam is string. Thanks in advance

IF you mean you want to call your SP by passing a string value then this is how you will need to change your code

strTSQL = "EXEC sp_gettitles '" & lngParam & "'"

hope this helps