declare @str varchar(20)

set @str = 'a b c d'

select @str as orig_string, replace(@str, ' ', '') as no_spaces

Regards

Phil

No. Each table can (by definition) have only one clustered index - and whether that is on the table's primary key field or on some other field is down...

The maximum worksheet size in Excel is 65,536 rows by 256 columns, so it sounds like you have hit that limit. However, you can of course have multiple worksheets...

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