Monday, February 27, 2017

sql replace coma seperated string

I have a string like this:


From this string i want to  remove 00001 with '' because this is a prefix of my every coma separated value.

 REPLACE((SUBSTRING(m_rx_nos,6,LEN(CAST(m_rx_nos AS VARCHAR(500)))-6)),(',0000'+ CONVERT(VARCHAR(100),f.pharminfoid_FK)),',') as m_rx_nos  

 Out Put:


vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.