We too have been using xcase.. and have been quite happy with the product (though not as happy with the responsiveness of the vendor)..

Are you able to use it...

Thanks.. I was hoping that there is something that could be done on the receiving end (the 2005 end).. but I suppose I can always just run a script to...

Thanks folks.. I'm begining to find places in the application framework that are leaving connections open... the hunt is on!

Thanks.. I may give that a try..

In the meantime, I'm just pulling the xml into a VFP mid tier object and processing it there..works well, though I would prefer to...

Thanks.. I had hoped for an sql server only solution.. but it all does look extremely cumbersome.  It seems such a simple requirement: all it needs is the ability to store...

Thanks guys..

Looks like Art's code incorporates the various suggestions and the corrections to the setclear..

Seems to work fine up through position 30...  which is all I need..

I appreciate...

Thanks.. that's the direction I finally took also..

ok.. found the problem, here is a set of working functions:

-----------------

CREATE FUNCTION dbo.BitClear(@nvalue BigInt, @nposition TinyInt) 

RETURNS BigInt AS 

BEGIN

Declare @nResult Bigint

Declare @nResult2 BigInt

set @nResult = 0

set @nResult =...

I'm playing around with your math versions, and I'm not getting quite the result I expected. Did I misinterpret what you had in mind?

-----------

CREATE FUNCTION dbo.BitClear(@nvalue BigInt, @nposition TinyInt) 

RETURNS...

Thanks..

string manipulation in VFP is blazingly fast.. I'll have to get used to it not being so in the SQL Server context..

and, yup, I do need to get around...

Thanks a bunch for turning me on to those functions in master..

Here is what I came up with.. and they seem to work fine. (I'm just getting into SQL Server.. so if I'm...

bummer..

I wonder if it would work to create a udf which called an extended stored procedure to emulate the functionality of the IIF()...

But I assume that even if it...

Thanks again

Ilmar

Thanks!

Looks like this should get me started...

and what would emulate:

BITCLEAR(nExpression1, nExpression2)

Clears a specified bit (sets it to 0) in a numeric value and returns the resulting value.

nExpression1

Specifies...

Thanks.. but what I'm looking for is a general solution which I can implement as a UDF.

I have a large number of Selects, Views, etc. to move from VisualFoxPro over...