I have been given a SQL query that I need to translate into LINQ, that's not a problem but there are a couple of items that I need help with in this particular query and those are the selecting column name as '' and also the concatination. Here is the query in question:

```
SELECT vessel_idx, 
       vessel_name, 
       spotlist_dp, 
       spotlist_bhp,
       spotlist_deck, 
       spotlist_bp, 
       spotlist_oilrec, 
       spotlist_fifi, 
       spotlist_rov,
       '' AS fixture_charterer,
       '' AS fixture_work,
CONCAT( fixture_charterer ,
        ' ', 
        mid(fixture_start,9,2),
        '/',
        mid(fixture_start,6,2)) AS next_charterer_info, 
        '' AS fixture_location,
        '0000-00-00 00:00:00' AS  fixture_stop, 
        '' AS fixture_note 
FROM tbl_vessels

WHERE vessel_type='AHTS'

AND current_location_spotlist_id = 2
AND fixture_start > '2016-02-12 08:30:00'
AND vessel_status = 'PPT'

ORDER BY fixture_stop

```

The usual stuff like AND, WHERE etc I can deal with it's purly these sections I'm struggling with. The selecting column as '':

```
SELECT '' AS fixture_charterer,
       '' AS fixture_work,

```

and the concatination

```
CONCAT( fixture_charterer ,
        ' ', 
        mid(fixture_start,9,2),
        '/',
        mid(fixture_start,6,2)) AS next_charterer_info, 
        '' AS fixture_location,
        '0000-00-00 00:00:00' AS  fixture_stop, 
        '' AS fixture_note

```

Many thanks