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.

Can someone help me translate this into SQL coding?

Thanks!

 

[vongrunt]

I guess problem is not in function itself... post relevant code you currently have here.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[rib742]

When I review the results without making the table it's fine; everything is returned in no time. It's just that when I go to copy the results or make table, that it takes for ever.