try this

'LC' + CAST(CAST(RIGHT (RTRIM(ID), 3) AS INT) + CAST(LEFT (LTRIM(ID), 3) AS INT) AS char)

please follow the advice in the link below ... you will get faster and more...

I am interested in this as well...I import files where potentially any one (or many) of 40...

Hi

as long as data length is as provided:

'A' + CAST(CAST(LEFT("yourdata", 3) AS int) + CAST(SUBSTRING("yourdata", 5, 3) AS int) AS char)

regards Graham

Howdy Wayne

without any more info its really hard to provide an answer

but maybe that GROUP BY and SUM (use BOL) will assist

you may find that if you follow the advice...

Hi Hugh

you may find that if you follow the advice in the link below that you get faster amd more detailed response...paritcularly if you provide example of what you expect...

Patrick...stumbled across this...may be worth a look at the Word docs

http://www.sqlservercentral.com/Forums/FindPost765551.aspx

regards gah

xyzzy 😀

Hi Patrick...I do use...

Hi Patrick

not knowing the volumes of data you have, the following method may not be appropriate, but this is one method I use to import up to 30K records into...

You really ought to read the advice given here

http://www.sqlservercentral.com/articles/Best+Practices/61537/

if you follow this advice then i am sure that you will get more response and answers that provide tested...

Since earlier post I have been searching this site for something that better meets my personal requirements and have come up with the following...you find this useful

USE tempdb

GO

--===== If the...

I am not sure that I fully understand the question without seeing the data and the expected results....however I have done something similar in the past which may provide you...

try this

http://www.aspfree.com/c/a/Microsoft-Access/On-Using-Passthrough-Queries-in-MS-Access/

jrw39 (7/8/2009)

---

Graham,

I connect in Access 07 to a data warehouse using ODBC.

I have linked tables from access db to SQL Server.

I need to be able to copy or...

How are you connecting Access 07 to SQL 2005?

Are you using an Access Project (ADP) or are you using linked tables to SQL?

regards graham