Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1582

Need help creating a view that can edit a string.

Show all headers | View raw

I receive this data in a column in a table: $8982162:2$905122:2$905PPA:
25$9601217:2$962B19:2$CSRI96:2$WDCOLACK:2$IDRBLACK2:2$IDRRED:2$

I need to make a view that will keep only the entries in that string
that start with 'WDCO' and omit the rest

So I need to edit text in the process of copying the data from the
table to the view. Hope this makes sense, sorry, I'm a newb.

SQL 2008 with patches.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Need help creating a view that can edit a string. Johnnyb <john.lutheran@gmail.com> - 2011-02-10 10:46 -0800
  Re: Need help creating a view that can edit a string. "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-02-10 15:16 -0500

csiph-web