Equivalent Oracle's INSTR Function in SQL server

Question

Equivalent Oracle's INSTR Function in SQL server

hkravitz

Right there with Babe

Points: 759
More actions
November 7, 2016 at 5:23 pm

#337179

Comments posted to this topic are about the item Equivalent Oracle's INSTR Function in SQL server

Viewing 6 posts - 1 through 6 (of 6 total)

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

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 1

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

hkravitz Right there with Babe Points: 759 More actions · Answer 2

hkravitz

Right there with Babe

Points: 759

November 17, 2016 at 1:07 am

#1912963

Good Point (the Data Type...)

hkravitz Right there with Babe Points: 759 More actions · Answer 3

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