Collections:
CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-SQL?
✍: FYIcenter.com
Transact-SQL is not a language designed for manipulating strings, but it does have two simple functions to locate and take substrings: CHARINDEX() and SUBSTRING().
The tutorial exercise below assumes two given strings: 'Pages: 18' and 'Words: 3240'. The objective is to calculate the number of words per page. Read the script below to see how this is done by using CHARINDEX() and SUBSTRING() functions:
DECLARE @sPages VARCHAR(40), @sWords VARCHAR(40); SET @sPages = 'Pages: 18'; SET @sWords = 'Words: 3240'; SET @sPages = SUBSTRING(@sPages, CHARINDEX(':', @sPages)+1, 20); SET @sWords = SUBSTRING(@sWords, CHARINDEX(':', @sWords)+1, 20); PRINT 'Number of words per page: ' + CONVERT(VARCHAR(20), CONVERT(INT, @sWords)/CONVERT(INT, @sPages)); GO Number of words per page: 180
If you are a PHP developer, you can get this done in a much quick way.
⇒ Concatenating Two Binary Strings in SQL Server
⇐ Inserting New Line Characters into Strings in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-07, 3182🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...