November 7, 2016 at 5:23 pm
Comments posted to this topic are about the item Equivalent Oracle's INSTR Function in SQL server
November 17, 2016 at 12:36 am
Hi, Hannan. Great thanks for your function.
I modify it to work on Case Sensitive Instance (be careful with variable names - use equal cases, in your function I have problem with @STR variable) and also change datatype to NVARCHAR for working with unicode strings (see 4 example with cyrillic symbol ?). You can grab modified version here: https://github.com/ktaranov/sqlserver-kit/blob/master/User_Defined_Function/udf_INSTR.sql
November 17, 2016 at 1:07 am
Good Point (the Data Type...)
November 17, 2016 at 1:30 am
kast218 (11/17/2016)
Hi, Hannan. Great thanks for your function.I modify it to work on Case Sensitive Instance (be careful with variable names - use equal cases, in your function I have problem with @STR variable) and also change datatype to NVARCHAR for working with unicode strings (see 4 example with cyrillic symbol ?). You can grab modified version here: https://github.com/ktaranov/sqlserver-kit/blob/master/User_Defined_Function/udf_INSTR.sql
Thank you for your comments
November 17, 2016 at 5:24 am
Hi
Works great, very helpful thanks
November 17, 2016 at 7:39 am
Thanks for the script.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply