Replacement of nvarchar column value to int

Sandeep Yadav

7y996

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourav Mukherjee7y ago
Have you tried to use typecasting to convert from one data type to other?
Jignesh Kumar7y ago
Hi Sandeep,

does you query resolved ?
Laxmidhar Sahoo7y ago
Thanks jignesh
Jignesh Kumar7y ago
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 Sahoo7y ago
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 Gupta7y ago
InClause works like ( '1', '2', '5'), if you are getting any error then post that error for analysis