-- where @ThisSearch is a posted (and sanitized) variable

SET @ThisSearch:="Brains";

SELECT
        columnID,
        columnFullName,
        CASE
                WHEN columnFirstName LIKE @ThisSearch THEN 20
                WHEN columnFullName LIKE @ThisSearch THEN 10
                WHEN columnLastName LIKE @ThisSearch THEN 10
                WHEN columnFullName LIKE @ThisSearch THEN 1
        END as relevance
FROM
        myTable
WHERE
        s.columnPublished

1.  -- where @ThisSearch is a posted (and sanitized) variable 
2.   
3.  SET @ThisSearch:="Brains"; 
4.   
5.  SELECT 
6.          columnID, 
7.          columnFullName, 
8.          CASE 
9.                  WHEN columnFirstName LIKE @ThisSearch THEN 20 
10.                  WHEN columnFullName LIKE @ThisSearch THEN 10 
11.                  WHEN columnLastName LIKE @ThisSearch THEN 10 
12.                  WHEN columnFullName LIKE @ThisSearch THEN 1 
13.          END as relevance 
14.  FROM 
15.          myTable 
16.  WHERE 
17.          s.columnPublished 

-- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
ALTER TABLE myTable ADD myColumn CHAR(2) NULL

-- Delete a column
ALTER TABLE myTable DROP COLUMN myColumn 

-- Reorder a column
ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;

1.  -- Add a column to an existing table (giving it datatype char(2) and allowing null) 
2.  ALTER TABLE myTable ADD myColumn CHAR(2) NULL 
3.   
4.  -- Delete a column 
5.  ALTER TABLE myTable DROP COLUMN myColumn 
6.   
7.  -- Reorder a column 
8.  ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn; 

UserFolder:="C:"
-- UserFolder := RegExReplace( MyInputField, "\\$")  ; gets rid of trailing slash if required

-- Method #1
count := 0
Loop, %UserFolder%\*.*, 0, 1 
  count++

-- note for future use:
; if A_LoopFileAttrib contains H,R,S
;	continue

1.  UserFolder:="C:" 
2.  -- UserFolder := RegExReplace( MyInputField, "\\$")  ; gets rid of trailing slash if required 
3.   
4.  -- Method #1 
5.  count := 0 
6.  Loop, %UserFolder%\*.*, 0, 1 
7.    count++ 
8.   
9.  -- note for future use: 
10.  ; if A_LoopFileAttrib contains H,R,S 
11.  ;    continue 

Error: The conditional operation failed.

Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component 
"MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error
row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An 
error occurred on the specified object of the specified component.  There may be error 
messages posted before this with more information about the failure.

1.  Error: The conditional operation failed. 
2.   
3.  Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component 
4.  "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error 
5.  row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An 
6.  error occurred on the specified object of the specified component.  There may be error 
7.  messages posted before this with more information about the failure.