Hi
Try This....
declare @value varchar(500)
declare @Whrcol varchar(500)
declare @Whrvalue varchar(500)
declare @TableDtls TABLE(TableName VARCHAR(500))
set @Whrcol='Product Cat3'
set @Whrvalue='IR DOME CAMERA'
set @value=('select [Table Name] from tblProductsCatalog where ['+ @Whrcol+ '] ='''+@Whrvalue+'''')
INSERT INTO @TableDtls(TableName)
execute (@value)
SELECT TableName FROM @TableDtls
Regards,
GVPrabu