Tag: substring

getting the second occurrence of a substring with PatIndex

With this query I get the postal code from an address and it works, but there are some cases where the address number’s length is 5 and so I get this instead of the postal code, is there any chance to …

Find a string inside a string and update in SQL Server

sql sql-server-2012 substring

I have a table like this : I need to replace the string inside the tag c24 tag.. Excepted output: I need to replace the letter ‘G’ to be replaced with ‘T’ like this inside c24 tag – HT0010001 and all the rest should be same unchanged… What I tired: Answer If the code always…

How to substring non constant strings?

sql sql-server substring tsql

I have the following query: With this query I try to associate the value of substring to my variable NUMERO_ORDINE when I find the “NR.” string in the Text column. Sometimes I don’t have the “NR.” string, so this query doesn’t work and I get wrong values from substring func…

How to get the part of a string after the last occurrence of certain character?

postgresql split sql string substring

I would like to have the substring after the last occurrence of a certin character. Now I found here how to get the first, second or so parts, but I need only the last part. The input data is a list of file directories: Unfortunately this is the data I have to work it, otherwise I could list it using

Tag: substring

getting the second occurrence of a substring with PatIndex

Find a string inside a string and update in SQL Server

How to substring non constant strings?

How to get the part of a string after the last occurrence of certain character?

Is there an elegant and efficient SQL way of listing all substring positions?

Converting Varchar(200) to YYYY-MM-DD format in Teradata SQL

Remove character from dynamic string

Converting NVARCHAR to INT after SUBSTRING using CHARINDEX and LEN

How to do sub-string calculations in SQL?

Dynamic Extraction of text – SQL