query help

[Googlehusband]

empid

------

11222,23,94

110,22222,111

12,1990000,1000

 

I need to get only values before comma(,)

11222

110

12

 

 what function I can use in sql server

 

 

[Googlehusband]

trim substring not working

[Spartan]

use CHARINDEX(),

look for comma, and print the values before it.

[ring_master]

string split anta..o saari google seyaraade @Googlehusband

[Googlehusband]

4 minutes ago, Spartan said:

use CHARINDEX(),

look for comma, and print the values before it.

Charindex worked baa google chesa.

[Googlehusband]

select substrin (empid,0,charindex(',',empid) from table vachindhi