Nope, not homework. I am a little old to be going to school. I like the ides that you gave for the design of the databases.

What I am wondering is...

Thank You Gila

I found my mistake

So silly, I am totally embarrassed

Andrew SQLDBA

I cannot add more than on data file that way.

Besides that, I try to not use the GUI

Andrew SQLDBA

Sorry, that did not work.

Andrew SQLDBA

Thanks Everyone

I knew it was something really simple that I could not think of

Andrew SQLDBA

I am so sorry Dave

Yes, your code worked perfect also.

Thanks to both of you

Andrew SQLDBA

Thanks Lutz

That was it, worked perfectly. I did have to modify the length from 11 to 10.

Andrew SQLDBA

Thanks Guys

That worked perfectly. I don't know why I did not think of using that. Maybe I am getting too old for this.

Andrew SQLDBA

Sweet, thank you

I will give that a try.

Andrew SQLDBA

Very nice, that is just what I was after.

Been one of those long days, my brain is about to drip out of my ears

Thanks alot

Andrew SQLDBA

Thanks Anyway, but I will stick to using the ASCII function that comes with SQL.

You could have also used a tally table.

SQL Server is not a Cursor based database, It...

The STUFF function was perfect. Did exactly what I was after.

Thanks

Andrew SQLDBA

I am coming close, but there is something that I am missing. I will keep at it to see if I can figure it out.

Thanks for your help in pointing...

Gail

What a great idea. Let me work on that to see if I can get it.

Thank you

Andrew SQLDBA

This is what I used to get the value that I needed

DECLARE @ProductName varchar(50)

SET @ProductName = '10494B-XL-Large.jpg'

SELECT SUBSTRING(@ProductName, 1, CHARINDEX('-', @ProductName) -1)

And the result is

Andrew SQLDBA