Top "Charindex" questions

What is the CHARINDEX (SQL SERVER) equivalent in POSTGRESQL?

I am trying CHARINDEX in Postgresql. But it says: function CHARINDEX() does not exist If no such inbuilt function exists …

postgresql charindex

Using CHARINDEX and SUBSTRING in a CASE statement

I need to evaluate a field with a CASE statement. The field name is Commodity and is a varchar(255). The …

sql-server sql-server-2012 substring case charindex

SQL- Get the substring after first space and second space in separate columns

I have a column as FullName containg FirstName, MiddleName, LastName in it. For example: FullName: Marilyn Kean Kirkland I want …

sql sql-server-2008 substring charindex

How to select a string between 2 identical characters in SQL

My initial string is Content-Disposition: attachment; filename="0001.zam" I want to select everything between the two " characters ("0001.zam" in this …

sql-server substring charindex

Python - Get string after and before a Character

I've this strings: "I have been working - 8h by day" "Like - 9H by Month" I'm trying to get …

python substring charindex

How to get string between two characters

I need to get the string between the - and the ·, which is the GigabitEthernet1/0/1 CW-3D13-SW1 - GigabitEthernet1/0/1 · …

sql sql-server substring charindex

tsql - extract string using SUBSTRING

I have a column where I need to extract the remainder of a string starting from "_". Example below: TF_Bskt …

sql-server-2008 tsql substring charindex

Using PatIndex and CharIndex like the InStr function

I tried using Instr for this, but didn't work, so I found the supposed to be equivalent using PatIndex and …

sql-server sql-server-2008 patindex charindex