Sql Doubt

[nikhilboorla]

i have table like this

 

empid          empname

1                  nikhil.B

2                  mahesh.G

 

i want output like this

 

empid          initials

1                   B

2                   G

 

 

[Osama Bin Gandhi]

SELECT SUBSTRING(myColumn, CHARINDEX('.', myColumn) + 1, 1000) AS Initial

[nikhilboorla]

can u give in oracle version instead of sql server version?

[vikuba]

can u give in oracle version instead of sql server version?

andhari names lo pakka '.'  dot untundhaa?>

[DaleSteyn1]

google man so easy adhi kooda meme cheppala