I need to modify a proc that someone else has created.
I need to remove any leading spaces from the contents of a variable in the proc.
The variable is defined as this:
@szQuickValue varchar(50) = null,
I see, in looking this up, that there is a BTrim function, but I'm not sure if that will work for me because the example doesn't look like it's taking a variable that starts with a "@".
I'm not an expert at Stored Procs.
I need to do this on a production system, no test system available, so I'm trying very hard to get this right the first time!