Hi Ashley,

You can use this syntax.

CASE WHEN ____ THEN _____  ELSE ____ END.

Replace the underscores with your logic, for example

CASE WHEN x_coord is null THEN 'NA'  ELSE x_coord END   

This syntax is already used for other logic in the gedts file, which will also demonstrate it's use.

Another way of doing it (not already demonstrated in the gedts file) is to use the ISNULL function, which returns the second parameter if the first is null, for example.

ISNULL(x_coord,'NA').

Regards,

Warwick

Hi Ashley,

If you get an error message "[SQL Server]Error converting data type varchar to float" you can add this around the numeric field, so that they are both text (varchar means text):

Cast([YourNumericField] as varchar)

Regards,

Warwick

Hi Warwick,

With my drill dates on my log templates I am wondering if it is possible to add a ' - ' between the 2 dates but only when Date2 is shown. The Dates need to be formatted as DD-MMM-YYYY

i.e. Date1 - Date2

or

Date1

Below is the function a use and it doesn't work.

Case When Date_Finalised = Date_Commenced or Date_Finalised is null Then Null ELSE ' - ' + cast([Date_Finalised] as datetime) END

If I use cast([Date_Finalised] as varchar) it works but the date is in the wrong format.

Could you please help

Cheers

Ash