DECLARE	@text as varchar(5)
SET	@text = 'Hello'

SELECT	lower(left(@text,LEN(@text)-1)) + UPPER(RIGHT(@text,1))

    'Need to ensure that Microsoft Scripting Runtime is enabled from the Tools, References menu
    
    DoCmd.SetWarnings False
    
    
    Dim myDirectory As String
    Dim myFile As File
'    Dim myFileCount As Integer
    
    Dim myFileName As String

DoCmd.TransferText acImportDelim, "MySavedFormat", "TableName", "C:\File.txt", True

DECLARE @start datetime
SET @start = '2013-12-01'

DECLARE @end datetime
SET @end = '2014-01-01'

DECLARE @fix int
SET @fix = CASE
             WHEN datepart(w,@start)

USE <database>
GO
CREATE PROCEDURE <procedure_name> AS

-- your query here

ALTER PROCEDURE <procedure_name> AS

UPDATE table_name
SET column_name = new_value
WHERE ID = ID_value

SELECT   partID

CASE subscription_id
  WHEN 456 THEN imageURL
  ELSE null
END

SELECT MessageTable.Title,
       2 AS mySort
FROM dbo.MessageTable
INNER JOIN dbo.PreacherTable
ON
dbo.PreacherTable.PreacherID=dbo.MessageTable.PreacherID
WHERE dbo.PreacherTable.PreacherID=1
UNION
SELECT Upper('Please select A Title'

FUNCTION MySplit(@Line int, @str nvarchar(255))
RETURNS nvarchar(255)

AS
BEGIN

DECLARE	@Output nvarchar(255)

SET @Output = CASE	@Line
				WHEN 1 THEN	substring(@Str,1,CHARINDEX(char(13),

SELECT		substring(Course,0,6)
			,count(substring(Course,0,6))
FROM		dbo.R_test
GROUP BY	substring(Course,0,6)