Replace ids with value

[User 12633930]

Hi , I have A nvarchar value Like This =id1-1,2 ; id2-1,3 ; .......i want return the nvarchar value with replace of id1,id2 values(i have a table id,value)

[Lost User]

REPLACE (Transact-SQL)[^]

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

[Richard Deeming]

Your THIRD copy of this question: Replace Ids With value - Database Discussion Boards[^] Replace ids with values[^]

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer