Last post Dec 01, 2010 01:56 AM by sirdneo
Nov 28, 2010 07:24 AM|Mobzam|LINK
I am developing web application using csharp and MS SQL as database. There is a column in table that is storing values which as numbers and letters. Letters are in front like JK26262, JK26263,JK26263.
Now I want to select numbers only from a table column and leave letters. In other words I want an select statement that will select values as follows:
How can Iachieve this?
Nov 28, 2010 07:36 AM|adeelehsan|LINK
If there are always 2 leading letters, then you can use the following:
Select right(columnName,LEN(columnName)-2) from tableName
Nov 29, 2010 03:32 AM|wmec|LINK
you can remove the leading non-numeric characters by substring
Dec 01, 2010 01:56 AM|sirdneo|LINK
Visit this link it will give you some idea how to split string in rows:-