SQL Substring Issue

Question

Hi I have a column called mix which is as follows

So the issue is I want to extract the digits of the left when a space is found, I am trying that with substring as shown below, I wonder why it is not working.

 select mix,  
 SUBSTRING(mix,1,CHARINDEX(' ',mix)-1)
 FROM tbl_xx
 where CHARINDEX(mix,' ')>0

Jesuraja · Accepted Answer · 2014-07-22 05:22:50Z

4

Find string comes first in CHARINDEX... Change it in WHERE condition

SELECT mix, SUBSTRING(mix, 1, CHARINDEX(' ',mix) - 1)
FROM   tbl_xx
WHERE  CHARINDEX(' ', mix) > 0

answered Jul 22, 2014 at 5:22

Jesuraja

3,8524 gold badges26 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Azar · Accepted Answer · 2014-07-22 05:23:13Z

0

Try this

select mix,  
 SUBSTRING(mix,1,CHARINDEX(' ',mix)-1)
 FROM tbl_xx
 where CHARINDEX(' ',mix)>0

Your where clause charindex is wrong check the above

answered Jul 22, 2014 at 5:23

Azar

1,86715 silver badges18 bronze badges

Comments

Sathish · Accepted Answer · 2014-07-22 05:33:52Z

0

Use LEFT

select mix,LEFT(mix,CHARINDEX(' ',mix)-1)
 FROM tabl
 where CHARINDEX(' ',mix)>0

answered Jul 22, 2014 at 5:33

Sathish

4,4854 gold badges36 silver badges60 bronze badges

Collectives™ on Stack Overflow

SQL Substring Issue

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related