Advanced Search

Return to Snippet

Revision: 67160
at August 18, 2014 08:23 by lottegis
Updated Code 
SELECT   CASE column WHEN 'search_string' THEN 'replace_string1' ELSE 'replace_string2' END AS column_rename
FROM     table


--Example
SELECT   OBJECTID,
         CASE PDF_NAME WHEN '' THEN '' ELSE '<a href="./doc/logbooks/'>' + PDF_NAME + '</a>' END AS LogBooks,
         CASE DAILY_REP WHEN '' THEN '' ELSE '<a href="./doc/Reports/'>' + DAILY_REP + '</a>' END AS DailyReport,
         STR_NAME, Shape
FROM     DatabaseName.TableName

Revision: 67159
at August 18, 2014 08:21 by lottegis
Updated Code 
SELECT   CASE column WHEN 'search_string' THEN 'replace_string1' ELSE 'replace_string2' END AS column_rename
FROM     table


'''Example
SELECT   OBJECTID,
         CASE PDF_NAME WHEN '' THEN '' ELSE '<a href="./doc/logbooks/'>' + PDF_NAME + '</a>' END AS LogBooks,
         CASE DAILY_REP WHEN '' THEN '' ELSE '<a href="./doc/Reports/'>' + DAILY_REP + '</a>' END AS DailyReport,
         STR_NAME, Shape
FROM     DatabaseName.TableName

Revision: 67158
at August 18, 2014 08:20 by lottegis
Initial Code 
SELECT   CASE column WHEN 'search_string' THEN 'replace_string1' ELSE 'replace_string2' END AS column_rename
FROM     table
Initial URL 









Initial Description





Example below









Initial Title





Conditional SQL statement









Initial Tags














Initial Language





SQL