Concatenate within a Pass Through Query

[rib742]

Good morning.

I understand the concatenate function as defined under faq701-4233 and am able to use it within a make table query.

My question is whether or not (and if how) can a function like this be used within an SQL Pass Through query? I'm running into some performance issues (3 hours to run) using it in the make table query and was wondering if I could improve it by using the function on the SQL server directly.

Thanks!

 

[LittleSmudge]

With a PassThrough query you need to use the version of SQL that the server database understands.

If your passthrough is connected to a SQL Server database then you'll need to convert the JET SQL to TSQL

I'd suggest you put this post on the SQL Server Programming board as there will be people there more versed in the finer details of that language.

http://www.tek-tips.com/threadminder.cfm?pid=183

'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.