On 18 Sep 2009, at 18:25, Raymond O'Donnell wrote:
On 18/09/2009 16:52, Jonathan Vanasco wrote:
I have a table with
name_first
name_middle
name_last
if i try concatenating as such:
SELECT
name_first || ' ' || name_middle || ' ' || name_last
FROM
mytable
;
I end
On 18/09/2009 16:52, Jonathan Vanasco wrote:
> I have a table with
> name_first
> name_middle
> name_last
>
> if i try concatenating as such:
> SELECT
> name_first || ' ' || name_middle || ' ' || name_last
> FROM
> mytable
> ;
>
> I end up with NULL as the
I have a table with
name_first
name_middle
name_last
if i try concatenating as such:
SELECT
name_first || ' ' || name_middle || ' ' || name_last
FROM
mytable
;
I end up with NULL as the concatenated string whenever a
