substring Image

substring

question
GreMoe avatar image
GreMoe commented Default

Trying to extract part of a string, but the field is xml data type. I just need the mac address from this field:

substring sql xml cast

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
Kev Riley avatar image
Kev Riley edited Default

using SUBSTRING to find the middle word in a sentence

sql server 2012 substring

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
Cricket132 avatar image
Cricket132 commented Default

How do I remove the first 12 characters AND drop the last character in a string?

substring left

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
ThomasRushton avatar image
ThomasRushton answered Default

break 1 field into many based on delimter

substring charindex delimiter

0 Likes

1Answer

0 Comments

question
Oleg avatar image
Oleg commented Default

extract substring between two delimters when more than one of those delimeters are present.

sql substring charindex

0 Likes

2Answers

0 Comments

question
ThomasRushton avatar image
ThomasRushton commented Default

SUBSTRING and CHARINDEX SQL SERVER

sql server substring charindex delimited-string

0 Likes

2Answers

1 Comment

question
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered Default

What is the % before the substring doing?

substring

2 Likes

1Answer

0 Comments

question
ThomasRushton avatar image
ThomasRushton edited Default

How to extract number which is of minimum length 2 from a string in SQL SERVER. Please see sample data

sql server substring regex

0 Likes

1Answer

0 Comments

question
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered Default

matching string of one table to substring of another table

sql-server-2008 sql joins substring string-function

0 Likes

1Answer

0 Comments

question
JohnM avatar image
JohnM commented Default

Substring and Patindex

substring patindex

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
srutzky avatar image
srutzky commented Default

Concat not working on Web Edition

concatenation substring

0 Likes

4Answers

2 Comments

question
DBANovice avatar image
DBANovice commented Default

Extract word after white space

tsql ssms substring charindex

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
seanlange avatar image
seanlange commented Default

i need to get substring data

functions substring

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Substring Question

substring

This question has an accepted answer. Accepted

1 Like

3Answers

3 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

get string between certain characters //

ssis string substring characters

0 Likes

2Answers

1 Comment

26 Posts
24 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.