I've had this and did not find a straightforward solution, so in the end I worked round it. But, as an alternative to having a dynamic filename, you might...

If 'first' = 'min' and 'last' = 'max', then this will do it:

select min(name) as 'first', max(name) as 'last'

from

where mark = 20

Regards

Phil

OK, assume that table 'tbl' contains two fields, 'utc' and 'date'.  utc is populated, but date is empty.  Here is a query that will populate date from utc:

update tbl

set date...

I think we were both referring to the ASC(AS(X,3) bit, which does not contain a trailing 'C'. I actually think you might have meant A$, rather than AS. ...

Hi John, your message is a bit terse. Please provide sample data and how you would like it to be sorted.

Cheers

Phil

So you want

200, 300, ...

as your resultset? If so, what does table 1 do?

Cheers

Phil

It's easier than you think - you're already on the right track. Try this:

declare @utcdate as float, @cvdate as datetime

set dateformat mdy

set @utcdate = 38279.813344907401

set @cvdate = @utcdate

select @utcdate...

Missed that. I have no idea what the as() function does. Any ideas, anyone?

Phil

Brett, you have created a calculation in your SELECT clause and given it a column heading of 'dnpisimport'. You are not giving the calculation an alias of 'dnpisimport' (this cannot...

No problem. I did a search on the web and found the following link about the FPT function ... do you think that is it?

http://www.basis.com/docsonline/commands/fpt_function.htm

If I create a user...

I've not heard of BBX, but this looks like straight BASIC to me. Having said that, I have no idea what the FPT function does, please elaborate.

It should then...

Thanks very much, I'll try that.

... tried it now and works a treat - thanks v much.

Phil

I'm sure that we can help you do, but you'll have to provide a bit more info before anyone can give you anything specific.

The general form of query that you'll...

Thanks - the returned recordset contains the info I need, but how do I query it as part of my script? sp_helpdevice itself returns just 0 (success) or 1...

Something like this?

select distinct a.ordernumber

from tblorder a

where a.ordernumber not in

(select distinct b.ordernumber

from tblorder b

where right(b.itemnumber,3) 'rtd')