Help with dynamic sql

[Het2109]

Hi all, I am using dynamic sql in my stored procedure. There is a problem. There are parameters in the dynamic sql query which are of type int or rather which are not of string type. So it is giving me error saying cannot convert type string to int. Can anyone help me out of this? Het Waghela :)Be Humble in Victory and Strong in Defeat.:) Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links

[jescgf]

hello:laugh: p

[Het2109]

Anything wrong with my question? Het Waghela :)Be Humble in Victory and Strong in Defeat.:) Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links

[Colin Angus Mackay]

Look in the SQL Server documentation for CAST or CONVERT

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious