Update Record Upper / Lower Case

Posted on By David Kittell

Upper Case

UPDATE [Members] SET [Email_1] = UPPER([Email_1]) WHERE [Email_1] = [Email_1]

Lower Case

UPDATE [Members] SET [Email_1] = LOWER([Email_1]) WHERE [Email_1] = [Email_1]
Originally Posted on March 19, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

FixedSplit

Posted on

public static string FixedSplit(string s, int len, string delim) { StringBuilder sb = new StringBuilder(s.Length + (int)(s.Length / len) + 1); int start = 0; for (start = 0; start < s.Length – len; start += len) { sb.Append(s.Substring(start, len)); sb.Append(delim); } sb.Append(s.Substring(start)); return sb.ToString(); } Originally Posted on February…

Read More

Ektron Rename Templates

Posted on

This script will rename template paths SET XACT_ABORT ON DECLARE @currval NVARCHAR(500) DECLARE @newval NVARCHAR(500) DECLARE @search NVARCHAR(500) DECLARE @replace NVARCHAR(500) SET @search = ‘/Index.aspx’ –string to find SET @replace = ‘/Default.aspx’ –replacement string DECLARE @pos INT DECLARE @id BIGINT BEGIN TRAN DECLARE curs CURSOR LOCAL FAST_FORWARD FOR SELECT template_id…

Read More

Subscribed Web Alert

Posted on

Will return you all the web alerts. The ID column represent the ID for the web alert SELECT * FROM subscriptions_tbl Will return you the folder(s) where the web alert is assigned The column Value_number represents the ID column from subscriptions_tbl The column Object_ID represents the folder ID where the…

Read More