Depends what kind of test data you are looking to create.

cm62597 (4/8/2009)

---

Thanks for you help....I guess I was having trouble telling you guys what I really needed. I could see it in my mind but hard to convey in...

Quickly, TraceID 2 is the default trace. You should never have more than 5 files and they don't get very big. the other trace, I suspect, is a...

Mind readers we are not. If you needed the results of your query then that is what you should have told us up front instead of indicating that you...

This:

select SUBSTRING(Field1,PATINDEX('%[^0]%',Field1),10)

FROM (

SELECT '05380101010000' AS Field1 UNION ALL

SELECT '05380101020000' UNION ALL

SELECT '05380101101000' UNION ALL

SELECT '05380011103000'

) TestData

does not return the result set you indicated you required.

In addition, not all MVP's are equal. We have seen solutions from MVP's that were not the best, and were actually of questionable value. It should be up...

Just checking, but did you also restart SQL Server?

Not only that, but that is what I thought was needed from the start, but I got confused by the subsequent posts until I had the OP show what was...

Try this:

select reverse(cast(cast(reverse(substring(col1,8,4)) as int) as varchar(4)))

I'm confused. Hightlight (BOLD) the values you are trying to extract:

05380101010000

05380101020000

05380101101000

05380011103000

Yes. Each NVARCHAR column could require up to 8000 bytes each.

Show how you are pulling out the values from the initial values.

Leading zeros or trailling zeros? looking at the data, I'm thinking trailing.

Lynn Pettis (4/8/2009)

---

Tara (4/8/2009)

---

Ok,i'll put in with some example.

I have tableA with CCode

ID CCode

1 98773

2 68790

3 62098

4 ...

If that is the only option, that may be what you need to do. As it is using SQL Server, you may want to verify with them that they...