SQL - FIRST() and LAST() aggregate functions return numeric type fields even from string types

[Ernesto Giannotta]

Hello Ruslan,

I'm getting strange results from the FIRST() and LAST() aggregate functions.

a query like this:

select FIRST(Artist) as Name 
FROM Artists 

returns a field containing the number 0

Shouldn't it return a string? 

I get it correct with group_concat().


Cool Runnings,
Erne.