Jerry:

Your suggestion works. It was another part of the stored procedure which is
at fault.

Thanks,
Sebastian

> on 9/13/00 3:35 PM, Jerry Tolentino at [EMAIL PROTECTED] wrote:
> 
>> If @FirstName is a CHAR or VARHCAR then you can just concatenate the
>> strings like so:
>> 
>> SET @FirstName =  @FirstName + '%'
>> 
>> Then just @FirstName in your query. SQL should handle all the quoting
>> issues... if I am not mistaken.
> 



------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to