Can FINDSTRING be an alternative to PATINDEX?

  • I have a column that has some numeric characters appended to the varchar column and I need the starting position of the numeric character in the string. I used patindex('%[0-9]%',<string>) in my t-sql, it works. But when I tried to convert that into SSIS expression, I am not finding any equivalent function to achieve this. Does anybody know how to do this?

  • I am looking to do the same thing. Have any luck yet?

  • No, I had no luck on this but I don't recall how I handled this. Please let me know if you could get answer to this. I am curious about it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply