I had the opportunity to work with Foxpro for a little while and all I can say about its sql capabilities is that until version 6 => it @^&*!

Anyway you could try:

SELECT...

PW,

Thanks for the Link, I was starting to get a little worried too because I have used that A LOT

the idea is something like:

-Create a new column with the target datatype : sp_repladdcolumn

-Run : Update TableName set Targetdatatye column = source data

-Drop old column : sp_repldropcolumn

-Synchronize

-Create a new column with...

do you mind to post what - print @strSQL - looks like after the last select

have a look at the sc command

 Such a simple solution to a problem that has consumed quite a bit of my time.

I have been there too, believe me Sometimes...

>> So, basically, as long as I get the vendor_number, bus_name and any one of the addresses, it would be ok <<

Here you go then

 select vendor_number, bus_name, Min(add1), Min(add2), Min(city),...

what is happening is that you are mixing things.

For example lets say you have determined that in the above data 002 and Bob are unique. Which address are you...

I don't think you are DECLARING any variable the way the poster requested.

when you write: 

variable  <tablename>.<rowname>%TYPE

in Oracle you are CREATING the variable with that datatype. So is not a...

And Just for the fun of it have you tried:

INSERT INTO tablename EXEC @hr=master..sp_OAMethod @vObject, 'ExecuteWithResults', @vResult , @vSQL

I haven't

HTH

>>> The user used by the app does not have direct access to MyTable therefore I have to do it this way. <<<

I have to differ on that one!

The...

The short anwser is NO!

You could using dynamic SQL create some sort of hack to get around it but you will end up with an entangled code hard to maintain....

Just to add my $0.02 ADP (Access Data Projects) are the ones that in my opinion should be used if you plan to use SQL Server on the Back end...

I don't fully understand what you want but this will get you going:

select case when uactequiv between  1 and 19 then 25

     when uactequiv between 20 and 21 then...

Dave,

sp_help_job WORKS for me! (with and without openrowset)

I know there are a lot of factors that can influence the final outcome but without further information those are usually hard to...