Here's one crazy technique that will work for your example...

If it doesn't work for your actual situation, please adjust your example to illustrate...

It's just a quick (and dirty) way to get a table of numbers. We need them from 0 to 200 because your string can be from 0 to 200 characters in...

So show the whole result...

And what do you want the output to look like?

Can you give an example?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65291

Here's one way...

--data

declare @x table ( id INT, t VARCHAR (200))

insert @x (id,t) values (1, 'These are three words')

insert...

Hi all,

Here's a simpler way...

--data

set dateformat mdy

declare @t table (ID int, Date datetime)

insert @t

          select 1, '1/1/06'

union all select...

Hi Sanket,

This is very commonly requested. These articles should help you find the technique that will work best for you...

http://www.sqlteam.com/item.asp?ItemID=2955

Great work, Jeff. I agree with your recommended approach, and that it's crazy design.

For fun, I thought I'd try to write it without...

Hi Brett,

I would either simply create the 2 separate UDFs and use those (see here: http://www.sqlteam.com/forums/forum.asp?FORUM_ID=11 for more date UDFs than you know what to do with).

Or, if the above...

Hi Sateesh

If this is a homework question, please post what you've tried so we can see you've made an effort.

In any case, please...

Good luck

Try this...

--data

if object_id('tempdb.dbo.#t') is not null drop table #t

create table #t (Product int, x varchar(20), Product_Choice varchar(12))

insert #t

          select 671703420, 'Department', '158779036X'

union all select 671703420, 'Document',...

Hi Aaron,

You request reminded me of this article...

http://www.sqlteam.com/item.asp?ItemID=1417