komal145 (9/25/2012)

---

Hi...I am getting this message
Msg 245, Level 16, State 1, Line 7
Conversion failed when converting the varchar value 'd1867 ' to data type int.

Below is my code:----

INSERT INTO TableA(
ID
)
SELECT
Title
FROM #table


please help.

INSERT INTO TableA(
                          ID
                           )
SELECT
                       Title
FROM #table
where Title not like '%[^0-9]%'

komal145 (9/26/2012)

---

Thank you .I filtered the title like isnumeric(title)=1