Well i really appreciate all the info, but i am development for a company and am trying to help our support department out. Periodically a client will have an issue...

sorry for my ignorance but that is what i do not know how to do.

i currently do not know how to script the indexes so that i can recreate them...

sorry it was just to easy to post in here rather than spend some time refreshing my memory

here is my solution

(CASE WHEN coc_name_type = 2 THEN coc_non_res_name ELSE ltrim(rtrim(cast(coc_name_key as...

Thank you

I am reading up on crosstab now.

I really appreciate all your help and the extra guidance

We can write functions/stored procedures but the problem comes from the 4GL Language.

THEY issue a query command (SELECT ..... WHERE... ) and we are only allowed to add to the...

Thank you for that. I am using a 4GL language and they only allow me 300 characters for my part of the query. So when i have 3-5 selection criterias...

1) I have written a program (delphi) that is using and adoconnection, command componenet.

2) Each users site has different server name/database name (nothing standardized on our part)

3) All table names...

i am sorry for all the confusion BUT relying on what i was told and not on what i knew the error wasn't with an apostrophe but actually looked like...

actually make that extra parameter added on as 'and ....'

the where clause is already built and added into the t-sql all i am able to add is 'and ...' to...

Not sure i can get away with using an inner join command but i will see what happens.

I am using(forced) a third party query builder. the main query is already...

sorry i am using the query's from within Delphi. That is how it assigns a variable name within an sql statement.