Help for this page

Select Code to Download


  1. or download this
    $sql = qq|
      select 'First' = first_name, 'Last' = last_name
    ...
    
    # Then split on comma.
    @select = split (/,/, $1);
    
  2. or download this
    $sql = qq|
      select 'First' = coalesce(first_name, ''),
        'Last' = coalesce(last_name, '')
      from table
    |;