> I have a stored procedure where I am passing a var called @SMSCancel bigint
>
> I need to pass this along with some other text into a nvarchar field, at the
> moment I have the following in my SP:
>
> -- insert the sponsor message
> INSERT INTO
> APPM8_WLCSponsors
> (ClientID, SponsorText)
> VALUES
> (@LocationID, 'To stop alerts, text No to +' + @SMSCancel + '.')


String concatenation only works on strings, therefore you have to CONVERT or
CAST your integer to a string.

@LocationID, 'To stop alerts, text No to +' + CAST(@SMSCancel AS char(12)) + '.'

FWIW I would normally define a phone number as a character column in the
database.

Nick



_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<