Mid String

Results 1 to 2 of 2

Thread: Mid String

  1. #1
    Join Date
    Dec 1969

    Default Mid String

    Can I do a mid string in a store procedure.<BR><BR>I have a string @PolicyNo which is 12 long and I want to break it up in to bits.<BR><BR>2, 3 and 7 long<BR><BR>I know about <BR><BR>SELECT LEFT(@PolicyNo, 2)<BR><BR>But how do I pass it into var??<BR><BR>Thanks for any help

  2. #2
    Join Date
    Dec 1969
    Indianapolis, IN

    Default In SQL Server...

    you would use SUBSTRING. Look it up to find out the syntax it expects. Post back if you have more problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts