Replacement of nvarchar column value to int

Question

Hi I have a table that stores personal informations. Personal infos have a field of vehicle type in which user can select multiple vehicles from multiselect dropdown list. So I have to store selected dropdown item(Multiple ids) in a single column of table(Column Name say RelatedVehicles and the values stored the column in my case is 1,29 in nvarchar(200) type column). Now I have to fetch this value(1,29) which nvarchar type to 'In' clause of another query like below: select * from VehicleMaster where vId in (Select RelatedVehicles from UserMaster where UID=1). Here vId in of Integer type and subquery returns nvarchar type value i.e ('1,29') . Please suggest... I have tried replacing the (,) to ',' so it becomes '1','29' now then it is not accepting it.

Laxmidhar Sahoo · Answer

Thanks jignesh

Sourav Mukherjee · Answer

Have you tried to use typecasting to convert from one data type to other?

Jignesh Kumar · Answer

Hi Sandeep, does you query resolved ?

Jignesh Kumar · Answer

Hi Sandeep, Please find example and change according to your requrement. create table VehicleMaster ( Vid int identity(1,1), VName varchar (100) ) insert into VehicleMaster values ( 'Maruti' ) insert into VehicleMaster values ( 'Innova' ) declare @INClause nvarchar(100) set @INClause= '1,2,3' select * from dbo.Split(@INClause, ',' ) select * from VehicleMaster where Vid in ( select * from dbo.Split(@INClause, ',' ))

Laxmidhar Sahoo · Answer

Hi sandeep the bellow code may solve your problem set @idList = '2,55' select val from dbo.split(@idList,',') or DECLARE @tags NVARCHAR(400) = '2,55' SELECT value FROM STRING_SPLIT(@tags, ',') WHERE RTRIM(value) '';

Amit Gupta · Answer

InClause works like ( '1', '2', '5'), if you are getting any error then post that error for analysis