Home Forums SQL Server 2005 SQL Server 2005 General Discussion Pass a string into SP and parse on space RE: Pass a string into SP and parse on space

  • May 10, 2013 at 4:12 am

    #1614118

    j2cagle (5/9/2013)

    Yes that helps...but I'm trying to resolve this without touching the VB code.

    I don't think you have a choice in the matter. The problem probably isn't within the SQL but within the VB code. It would help us to help you if you posted both the VB code and the SQL code so we could verify.

    Are you using the DTS.Variable.ToString to pass the string from the VB code to the SQL?

    Bevan's suggestion is the best (exactly what I would do). I.E., using CHARINDEX() and then LEFT() in the T-SQL code, but if that's not working for you, then your issue is in the VB code, not in the T-SQL.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.