Monday, February 20, 2012

Need to write a stored procedure

Hi,

I need to write a stored procedure to check if the string = "web_version" exists in another string called FromCode.

The stored procedure accepts 2 parameters like this:

Create proc [dbo].[spGetPeerFromCode]( @.FromCode VARCHAR(50)) (@.WebVersionString VARCHAR(50))as

please assist.

Check Books On Line for theSubstring function.

No comments:

Post a Comment