I have a ms sql table called CallPN and in that table there is a column called phone which consist of phone numbers such as 19,9995551212. I need to just take out the 19, but leave the rest. How do I do that. I have a statement to put in the 19, but now i need to delete that 19,. Does anyone have a sql statement that can strip this out. by the way it is a nvarchar column.