Home
Search results “Oracle trailing spaces”
Oracle LENGTH Function
 
01:23
https://www.databasestar.com/oracle-length/ The Oracle LENGTH function allows you to find the length of a string, also known as the number of characters in a string. It’s a common feature in different languages, and SQL is no different. The LENGTH function only has one parameter: LENGTH ( string_value ) The parameter is the string_value which is the value to check the length of. The function returns a number that represents the number of characters in the function. Some points to remember about the Oracle LENGTH function: If string_value is NULL, then LENGTH will return NULL. If string_value is an empty string, the LENGTH will return NULL. The string_value can be any of the character data types - CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, NCLOB. If the string_value is a CHAR data type, then the LENGTH will include any trailing spaces in the value. For more information about the Oracle LENGTH function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-length/
Views: 354 Database Star
SQL Tutorial - 40: The TRIM() Function
 
02:32
In this tutorial we'll see how we can remove leading and trailing spaces from strings using the TRIM() function.
Views: 25938 The Bad Tutorials
Let's Learn SQL! Lesson 85 : Trimming Trailing Spaces and Characters
 
04:32
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn how to use the Trim Command to trim trailing spaces and characters!
Tutorial#39 How to Remove Character from Spaces/String/Column Using with  TRIM function
 
09:57
SQL TRIM function removes all space characters from the Right-hand side and Left hand side of a string or How to use trim Function in Oracle SQL or how to remove spaces using TRIM Function or How to use LTRIM, RTRIM & TRIM functions step by step. Assignment link: https://drive.google.com/open?id=1_tgBy7oWNWM6B4pww7oXOmHTxiyNhH86 In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 110 EqualConnect Coach
Oracle RTRIM Function
 
03:27
https://www.databasestar.com/oracle-trim/ The Oracle RTRIM function allows you to remove a specific character from the right side of a string. It’s one of the most commonly used string manipulation functions in SQL, in my experience. The “R” in “RTRIM” stands for “right”. It’s often used to remove spaces from the right of a string. However it can be used to remove other characters, such as trailing slashes from URLs. The syntax for the RTRIM function is: RTRIM(input_string, [trim_character]) The input_string is the text you want to remove characters from. It can be any kind of expression, such as a specific text value or a column. The trim_character is the character you want to remove from the right of the string. It’s an optional parameter, and if you don’t specify it, then a space character is used by the function. The parameters can be any type of string. The function will return either a VARCHAR2 or a LOB data type, depending on the type of data you specify in the parameters. You can specify more than one value for the trim_character, and the RTRIM function will remove both characters from the right of the string. The function is similar to the LTRIM value, where LTRIM removes characters from the left of the string. For more information on the RTRIM function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-trim/
Views: 129 Database Star
How to use LTRIM,RTRIM & TRIM functions
 
06:40
How to use LTRIM, RTRIM & TRIM functions step by step.
Views: 6508 OCP Technology
VMWare: Microsoft, Oracle trailing us
 
03:23
Paul Maritz, CEO of VMWare, says Microsoft and Oracle have both struggled to perfect virtualization.
Views: 26 CNN Business
Sql Training Online - Sql Trim, Rtrim, Ltrim
 
02:56
Learn about the Trim, RTrim, LTrim functions in the SQL Language. Visit http://www.SqlTrainingOnline.com for 30 more FREE videos.
Views: 11391 Joey Blue
string remove extra white spaces in t-sql
 
02:26
Code in T-SQL to remove extra white spaces from a string. Download source code at: https://drive.google.com/file/d/0B61-MHkMYqM4cWc2bzJvQlFReGs/ Like and share. It's FREE too :) Follow us on Facebook https://www.facebook.com/AllTech-1089946481026048/
Views: 170 AllTech
53977022 SQL TRIM
 
11:15
Views: 47 mhscom53
SQL 092 String Scalar, TRIM or How can I remove leading or trailing characters?
 
01:31
Explains the String Scalar Function TRIM to remove leading or trailing characters. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 756 cbtinc
INSTR-LEFT-RIGHT-LPAD-RPAD Commands On the HeidiSQL @sadikemrah
 
09:03
INSTR-LEFT-RIGHT-LPAD-RPAD Commands On the HeidiSQL
Views: 9 Sadik Emrah
008 - String Functions - ASCII, LTRIM, RTRIM
 
04:02
how to use the fllowing String functions in SQL ASCII LTRIM RTRIM TRIM
Views: 123 Rishabh Jain
String Functions in SQL Server part-II || SOUNDEX, DIFFERENCE, LEFT, LEN, LOWER, LTRIM in SQL
 
03:48
This video will provide you the details of each string functions in SQL Server 2014. I'll be walking through each and every kinds of build in function which are available in SQL Server in my next videos. Previous video for more String Functions https://www.youtube.com/watch?v=6cgn44DZ7w8 ******************************************************************************* SOUNDEX (Transact-SQL) Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings. The SOUNDEX() returns a four digit code for a varchar value passed to it. The same code is returned for all those names whose pronunciation is similar.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse SOUNDEX ( character_expression )  Arguments character_expression Is an alphanumeric expression of character data. character_expression can be a constant, variable, or column.  Return Types Varchar ******************************************************************************* DIFFERENCE (Transact-SQL) Returns an integer value that indicates the difference between the SOUNDEX values of two character expressions.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse DIFFERENCE ( character_expression , character_expression )  Arguments character_expression Is an alphanumeric expression of character data. character_expression can be a constant, variable, or column.  Return Types int ******************************************************************************* LEFT (Transact-SQL) Returns the left part of a character string with the specified number of characters.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse LEFT ( character_expression , integer_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convertcharacter_expression. integer_expression Is a positive integer that specifies how many characters of the character_expression will be returned. If integer_expression is negative, an error is returned. If integer_expression is type bigint and contains a large value, character_expression must be of a large data type such as varchar(max).  Return Types Returns varchar when character_expression is a non-Unicode character data type. Returns nvarchar when character_expression is a Unicode character data type. ******************************************************************************* LEN (Transact-SQL) Returns the number of characters of the specified string expression, excluding trailing blanks.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse LEN ( string_expression )  Arguments string_expression Is the string expression to be evaluated. string_expression can be a constant, variable, or column of either character or binary data.  Return Types bigint if expression is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise, int. ******************************************************************************* LOWER (Transact-SQL) Returns a character expression after converting uppercase character data to lowercase.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse LOWER ( character_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.  Return Types varchar or nvarchar ******************************************************************************* LTRIM (Transact-SQL) Returns a character expression after it removes leading blanks.  Syntax -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse LTRIM ( character_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type, except text, ntext, and image, that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.  Return Type varchar or nvarchar
Views: 355 Softtech forum
Tutorial#36  LPAD function in Oracle SQL Database |  How to add string  at front of string
 
10:30
The Oracle LPAD function is used to add extra characters to the Left of a text value. This is called “padding” and the function is called LPAD because the L stands for “Left” and it “Left pads” a text value or How to use LPAD in Oracle SQL or Learn how to add strings with Lpad in SQL or How to use LPAD Function in Oracle SQL Database Assignment link: https://drive.google.com/open?id=1NH4ckL4A9exy4l1ast7TkvrrSPNnEc9h In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. Link for assignment: UPPERfunction in SQL https://drive.google.com/open?id=1ibjDTDX-CiPUShpf8j9kLkLjkYRdN9_e follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 66 EqualConnect Coach
String Functions in SQL Server part-IV || REPLACE, REPLICATE, REVERSE, RIGHT, RTRIM functions in SQL
 
03:57
This video will provide you the details of each string functions in SQL Server 2014. I'll be walking through each and every kinds of build in function which are available in SQL Server in my next videos. Previous video for more String Functions String Function Part I https://www.youtube.com/watch?v=6cgn44DZ7w8 String Function Part II https://www.youtube.com/watch?v=RmyT87mstzc String Function Part III https://www.youtube.com/watch?v=lQVnQKeGlf0 ***************************************************************************************** REPLACE (Transact-SQL) Replaces all occurrences of a specified string value with another string value.  Syntax REPLACE ( string_expression , string_pattern , string_replacement )  Arguments string_expression Is the string expression to be searched. string_expression can be of a character or binary data type. string_pattern Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string (''), and must not exceed the maximum number of bytes that fits on a page. string_replacement Is the replacement string. string_replacement can be of a character or binary data type.  Return Types Returns nvarchar if one of the input arguments is of the nvarchar data type; otherwise, REPLACE returns varchar. Returns NULL if any one of the arguments is NULL. If string_expression is not of type varchar(max) or nvarchar(max),REPLACE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to a large-value data type. ***************************************************************************************** REPLICATE (Transact-SQL) Repeats a string value a specified number of times.  Syntax REPLICATE ( string_expression ,integer_expression )  Arguments string_expression Is an expression of a character string or binary data type. string_expression can be either character or binary data. Note : If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to the appropriate large-value data type. integer_expression Is an expression of any integer type, including bigint. If integer_expression is negative, NULL is returned.  Return Types Returns the same type as string_expression. ***************************************************************************************** REVERSE (Transact-SQL) Returns the reverse order of a string value.  Syntax REVERSE ( string_expression )  Arguments string_expression string_expression is an expression of a string or binary data type. string_expression can be a constant, variable, or column of either character or binary data.  Return Types varchar or nvarchar ***************************************************************************************** RIGHT (Transact-SQL) Returns the right part of a character string with the specified number of characters.  Syntax RIGHT ( character_expression , integer_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convertcharacter_expression. integer_expression Is a positive integer that specifies how many characters of character_expression will be returned. If integer_expression is negative, an error is returned. Ifinteger_expression is type bigint and contains a large value, character_expression must be of a large data type such as varchar(max).  Return Types Returns varchar when character_expression is a non-Unicode character data type. Returns nvarchar when character_expression is a Unicode character data type. ***************************************************************************************** RTRIM (Transact-SQL) Returns a character string after truncating all trailing blanks.  Syntax RTRIM ( character_expression )  Arguments character_expression Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.  Return Types varchar or nvarchar
Views: 90 Softtech forum
Trim Function in SQL Server - SQL in Sixty Seconds #040
 
00:55
Trim is one of the most frequently used operation over String data types. A developer often come across a scenario where they have the string with leading and trailing spaces around string. However, in SQL Server there is no TRIM function. In this video we will learn how quickly we can achieve same functionality. Read for more info: http://bit.ly/Wb7UBu
Views: 13818 Pinal Dave
Character functions ( lpad, rpad , replace, trim)
 
09:51
http://ytwizard.com/r/PLkVTt http://ytwizard.com/r/PLkVTt Oracle Database 12c SQL Certified Associate 1Z0-071 Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations & scripts are attached
How to use RegEx to remove whitespace
 
01:26
Download the free Informatica PowerCenter mapping here: https://community.informatica.com/solutions/powercenter_remove_whitespace. Regular expressions provide the foundation for describing or matching data according to defined syntax rules. Using Regular Expressions, it is simple to search for a specific word or string of characters. You can search for words of a certain size. You can search Numbers, Punctuation Characters, Patterns and so on. At the same time, Regular expression can be very confusing because the learning curve for Regular expression may not be very easy for everyone. This video shows you how to use the RegEx in to remove unwanted whitespace or empty space from the data.
Views: 4523 InfaMarketplace
LDIF Files Removing Trailing Spaces with sed
 
04:07
With openLDAP LDIF files a trailing white space at the end of a line is used to denote that the attribute should be encoded. This is often an issue and we can easily remove the offending spaces. Using the sed stream editor we can run though one or more files removing spaces from the end of lines. Additionally you can find my video courses on Pluralsight: http://pluralsight.com/training/Authors/Details/andrew-mallett and take time to see my own site http://www.theurbanpenguin.com
Views: 1144 theurbanpenguin
Trim or remove spaces on column headers with Power Query #3: (M)agic (M)ondays
 
04:31
In today's (M)agic (M)ondays I will show you how to trim or remove spaces in column headers using Power Query. Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Join our (M)agic (M)ondays! Series - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #MAGICMONDAYS #CURBAL #POWERQUERY #POWERBI ► Linkedin: https://goo.gl/3VW6Ky
Views: 1318 Curbal
SQL LEN Function - how to use LEN Function
 
02:06
SQL LEN function returns the length of the specified string. It is important to note that the LEN function does not include trailing space characters at the end the string when calculating the length. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Let's Learn SQL! Lesson 70 : What is the Percent_Rank Over Statement?
 
03:17
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about the Percent_Rank Over statement in Rank!
Carga masiva de datos con archivos de control oracle/sql loader
 
09:36
- Comando para ejecutar .ctl desde la terminal : sqlldr userid= usuario/contraseña control=archivo.ctl -Archivo ctl OPTIONS (SKIP=1) LOAD DATA CHARACTERSET WE8ISO8859P1 INFILE '/home/pau/Escritorio/ARCHIVOS/practica/Practica1_201314745/MIAPRACTICA1-V2.csv' INTO TABLE DATOSTOTALES TRUNCATE FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS( GUID, NOMBRE, APELLIDO, CORREO, TELEFONO, COMPANIA, JNOMBRE , JAPELLIDO, PAISORIGEN, CIUDADORIGEN, DIRECCION, TARJETA1, NOMBRETIPO1, VENCIMIENTO1 DATE 'DD/MM/YYYY' nullif VENCIMIENTO1 = 'NULL' , SALDO1, TARJETA2, NOMBRETIPO2, SALDO2, VENCIMIENTO2 DATE 'DD/MM/YYYY' terminated by whitespace nullif vencIMIENTO2 = 'NULL' )
Views: 63 Pau Vasquez
MySQL Tutorial : RTRIM command
 
01:48
MySQL rtrim function is used to remove white space from the ending of the string for more information log on to http://www.codesnipr.com/snippet/895/SQL-RTRIM-command
Views: 243 MrAmitweb
Excel Power Query & Data Cleansing Part 1: Different Ways to Format Data Using Power Query
 
37:04
*** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html In this 1st of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to format your messy data using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-content/uploads/2016/06/Power-Query-Data-Cleansing-Excel-Workbooks.zip This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2010, 2013 & 2016 versions. You will learn the following topics: Intro from John Michaloudis & Oz du Soleil 12:10 – Intro to Power Query (Get & Transform in Excel 2016) 16:30 – Trim leading & trailing spaces 20:30 – Format “text” Dates & Values using Excel v Power Query 24:15 – Parse URLs using Excel v Power Query 27:55 – Transform & automate reports from an ERP system (e.g. Oracle, SAP, QuickBooks) into a flat Excel file Watch the rest of the training videos here: VIDEO 2: Format & extract data using Excel Formulas & Excel's Data Tools https://www.youtube.com/watch?v=9q4_QLr5VoA VIDEO 3: Consolidate Workbooks & Worksheets using Power Query https://www.youtube.com/watch?v=3EMACCDmsVU *** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html Please share, like & leave your comments below. Thank You, JOHN MICHALOUDIS www.MyExcelOnline.com
Views: 23021 MyExcelOnline.com
Hints and Tips - Avoiding never ending locks - part 2
 
03:57
Row locking is a critical component of ensuring the integrity of your data inside the database. But locks of extended duration can easily create system-wide problems in your applications. This quick tip gives you some ideas for handling locks better. ====================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 783 Connor McDonald
SQL SPACE Function - how to use SPACE Function
 
01:07
SQL SPACE function returns a string with a specified number of spaces. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
SQL 116 - SQL SERVER - String Concatenation and LTRIM RTRIM functions
 
05:17
englishspacedog YouTube tutorial from Canada http://www.herostratus.ca/PC.htm How to concatenate text and how to trim spaces ellipsis ... function SELECT tblGALAXIES.GalaxyID, tblGALAXIES.GalaxyName, tblSTARS.StarID, tblSTARS.StarName, tblPLANETS.PlanetID, rtrim(ltrim(tblPLANETS.PlanetName)) + ' ' + tblSTARS.StarName AS PlanetName, tblPLANETS.PlanetWeight /(SELECT PlanetWeight FROM tblPLANETS WHERE PlanetID = 3) AS WeightInEarths FROM tblGALAXIES LEFT JOIN tblSTARS ON tblGALAXIES.GalaxyID = tblSTARS.GalaxyID LEFT JOIN tblPLANETS ON tblSTARS.StarID = tblPLANETS.StarID ORDER BY tblGALAXIES.GalaxyName, tblSTARS.StarName, tblPLANETS.PlanetName;
Views: 609 MS / Access
string remove char in t-sql
 
02:52
Code in T-SQL to remove a char from a string. Download source code at: https://drive.google.com/file/d/0B61-MHkMYqM4RVFwTnF5SFFhNDg/ Like and share. It's FREE too :) Follow us on Facebook https://www.facebook.com/AllTech-1089946481026048/
Views: 38 AllTech
SQL Database Administration Day 2
 
01:12:49
In this video, we will learn the tools used for data mining and we will focus on the most frequently used string functions 1. UCASE Converts a string to upper-case 2. LCASE Converts a string to lower-case 3. UPPER Converts a string to upper-case 4. LOWER Converts a string to lower-case 5. LENGTH Returns the length of the specified string (in bytes) 6. LTRIM Removes leading spaces from a string 7. TRIM Removes leading and trailing spaces from a string 8. RTRIM Removes trailing spaces from a string 9. LEFT Extracts a substring from a string (starting from left) 10. RIGHT Extracts a substring from a string (starting from right) 11. MID Extracts a substring from a string (starting at any position) 12. SUBSTR Extracts a substring from a string (starting at any position) 13. REPLACE Replaces all occurrences of a specified string 14. CONCAT Concatenates two or more expressions together 15. CONCAT_WS same thing as CONCAT BUT with a separator between them and 16. LIKE OPERATOR 17. BETWEEN PRACTICALS =========== BETWEEN OPERATOR ================= SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE DATEOFBIRTH BETWEEN '1960-08-28 ' AND '1970-08-28' ORDER BY DATEOFBIRTH ASC USE LTRIM, RTRIM AND TRIM ======================== SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(FIRSTNAME) = 4 SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(TRIM(FIRSTNAME)) = 4 UPPER LOWER - ORACLE SQL SERVER - UCASE OR LCASE SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(FIRSTNAME) = 5 SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(FIRSTNAME) = 6 SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(FIRSTNAME) = 7 SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LENGTH(FIRSTNAME) = 8 FIRSTNAME WHICH ENDS WITH N ============================ SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE (OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE RIGHT (FIRSTNAME, 1) ='N' TO BE SURE - ADD TRIM ------------------------------ SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE RIGHT(TRIM(FIRSTNAME), 1) ='N' FIRSTNAME WHICH STARTS WITH N ============================= SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE LEFT(TRIM(FIRSTNAME), 1) ='N' FIRSTNAME THAT THE SECOND LETTER IS 'A' =============================================== SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE MID(FIRSTNAME, 2,1) = 'A' SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE MID(TRIM(FIRSTNAME), 2,1) = 'A' SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE SUBSTR(TRIM(FIRSTNAME), 2,1) = 'A' SUBSTR - ORACLE MID - SQL SERVER FIRSTNAME THAT THE SECOND LETTER IS AN 'ARC' =============================================== SELECT STUDID, SURNAME, LOWER(FIRSTNAME), LCASE(OTHERNAMES), GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE MID(FIRSTNAME, 2,3) = 'ARC' YOU CAN ALSO USE LIKE OPERATOR TO SEARCH ======================================= SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE SURNAME LIKE 'S%' SELECT STUDID, SURNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WHERE FIRSTNAME LIKE 'A%' REPLACING 'HU' WITH 'HOU' IN 'HUDE' ================================== SELECT REPLACE (SURNAME, 'HU', 'HOU') AS LASTNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION SELECT REPLACE(SURNAME, 'HOU', 'HU') AS LASTNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION REPLACE 'SACLE', 'HUDE') ======================== SELECT REPLACE(SURNAME, 'SACLE', 'HUDE') AS LASTNAME, FIRSTNAME, OTHERNAMES, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION CONCATENATING TWO COLUMNS ======================== NO SPACE SELECT CONCAT(SURNAME, FIRSTNAME) AS STUDENTNAME, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION WITH SPACE SELECT CONCAT_WS(' ', SURNAME, FIRSTNAME) AS STUDENTNAME, GENDER, DATEOFBIRTH FROM STUD_REGISTRATION
Views: 33 BTC GHANA LTD
How to remove spaces in a column
 
01:20
In this short video you will see how to remove unwanted spaces in a column in Microsoft Excel 2010.
Views: 1591 Ulrika Hedlund
SDU Tools   29   Left Pad and Right Pad a string in T-SQL
 
01:41
SDU Tools are free tools for SQL Server developers and DBAs. This tool is used to pad a string with any character, either to the left or to the right. The input can be any type (string or number) that can be implicitly cast to a string. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 94 SQL Down Under
SDU Tools   36   ASCII Only Function for T-SQL
 
01:53
SDU Tools are free tools for SQL Server developers and DBAs. This tool is used to remove non-ASCII characters from strings (varchar, nvarchar). Optionally, it can remove embedded control characters like carriage returns or line feeds. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 69 SQL Down Under
Len Function SQL Server
 
01:38
Published on Aug 13, 2017: In this video tutorial, we will learn about the len function for sql server. This function gives us the total length for a given string. However, this function does not count trailing spaces. Please find below the SQL used for the video Declare @StringLength as varchar(100)='Hello World!!!' --Len Returns the Length Of a String Select Len(@StringLength) As LengthOfString Previous Video:https://youtu.be/m9fwu2YKVKM SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server! https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw Download the sample database used for the demo here: https://goo.gl/SVyVmT Our Playists: SQL Playlist :https://goo.gl/PS5Ep6 DAX PlayList : https://goo.gl/S4W41D Power BI PlayList: https://goo.gl/dXxvnB Power Query Playlist: https://goo.gl/5QS7P4 ABOUT DAGDOO: Website: Home Page: http://www.dagdoo.org/ Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/ Questions? Comments and SUGESTIONS? You will find me here: Twitter: @dagdooe Category: Science & Technology License: Standard YouTube License
Views: 74 Learn 2 Excel
Fayose Speaks On Leadership Style, PDP Loss, Ekitigate, Other Issues (PT2) 11/05/15
 
13:21
Ekiti State Governor, Ayodele Fayose, opens up on the many controversies trailing the 2014 Ekiti election that produced him as Governor, PDP's loss in the 2015 elections, and his many battles at the state and national level. For more information log on to http://www.channelstv.com
Views: 59227 Channels Television
Learn Excel - Some Trailing Minus Numbers - Podcast 2201
 
04:24
A question from my Nashville Power Excel seminar: How to deal with downloaded data where some cells contain trailing minus numbers? It is tempting to fix them manually or to use =IF(RIGHT(B2,1)="-",-1*LEFT(B2,LEN(B2)-1),B2) Text to Columns is a fast way to deal with this Choose the whole column Data, Text to Columns, Delimited, Next, Make sure there are no lines, Next, Options: Trailing Minus In fact, since Trailing Minus is the default, there is a faster way: Select whole column and Alt+D E F To download this workbook: https://www.mrexcel.com/download-center/2018/05/some-trailing-minus-numbers.xlsx List of upcoming seminars: https://www.mrexcel.com/press-appearances/
Views: 1035 MrExcel.com
Decentralizing Attribute-Based Encryption
 
01:05:50
We present a Multi-Authority Attribute-Based Encryption (ABE) system. In our system, any party can become an authority and there is no requirement for any global coordination other than the creation of an initial set of common reference parameters. A party can simply act as an ABE authority by creating a public key and issuing private keys to different users that reflect their attributes. A user can encrypt data in terms of any boolean formula over attributes issued from any chosen set of authorities. Finally, our system does not require any central authority. In this talk, I will present our system and discuss its proof, which employs dual system encryption techniques. Our system uses bilinear groups of composite order, and we prove security under static assumptions in the random oracle model. This is joint work with Brent Waters.
Views: 1684 Microsoft Research
MSSQL - Add leading zeros to the integer
 
01:11
http://howtodomssqlcsharpexcelaccess.blogspot.ca/2016/04/mssql-add-leading-zeros-0-to-integer.html
Views: 1530 Vis Dotnet
String Functions like LEN - Substring in SQLServer
 
09:33
http://www.sqlserver2008tutorial.com In this video tutorial on SQL Server 2008, we cover sql string functions that are commonly used. Here are the SQL functions: LEN -- This sql function returns the length of an expression RIGHT -- This sqlserver function returns the number of characters starting from the right LEFT - This sqlserver function returns the number of characters starting from the left LOWER -- MS SQL function converts the string to lower case UPPER - MS SQL function converts the string to upper case REPLACE -- Important function helps to replace characters in a field with another SUBSTRING function -- Use this to return portion of a string expression CHARINDEX -- You can find starting position of character in a string LTRIM -- This function in SQL 2008 removes empty spaces from the left RTRIM - function in SQL 2008 removes empty spaces from the right
Views: 4815 baghul
Close encounter with Stars and Stripes
 
01:42
A great thing about sailing in San Diego, you will encounter a wide variety of boats from container ships to aircraft carriers to a replica of the original schooner America, to the latest BOR90, BMW Oracle and IACC International America's Cup Class boats like Stars and Stripes Photographs at http://gadeyne-us.spaces.live.com/
Views: 550 Philippe Gadeyne
Remove Spaces With Excel TRIM Function
 
02:18
http://www.contextures.com/30excelfunctionsin30days30xl30d.html Use the TRIM function in Excel to remove spaces in a text string. The TRIM function removes spaces at the start and end of the text string, and all but single spaces between words. However, the TRIM function cannot remove a non-breaking space that was copied from a website. Watch this video to see how to use the Excel TRIM function, and remove extra spaces.
Views: 37586 Contextures Inc.
Regular Expressions (RegEx) Tutorial #9 - Alternate Characters
 
03:48
DONATE :) - https://www.paypal.me/thenetninja ----- COURSE LINKS: + RegEx101 - https://regex101.com/ + Course files - https://github.com/iamshaunjp/regex-playlist + Atom editor - https://atom.io/a + CMDER - http://cmder.net/ ======== Other Tutorials ========= ----- NODE.JS TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9gcy9lrvMJ75z9maRw4byYp ----- MONGODB TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9jpvoYriLI0bY8DOgWZfi6u ----- SUBSCRIBE TO CHANNEL - https://www.youtube.com/channel/UCW5YeuERMmlnqo4oq8vwUpg?sub_confirmation=1 ======== Social Links ========== Twitter - @TheNetNinja - https://twitter.com/thenetninjauk Patreon - https://www.patreon.com/thenetninja
Views: 7763 The Net Ninja
Let's Learn SQL! Lesson 75 : Writing out Subqueries!
 
03:34
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, take a stab at writing these subqueries!
SQL 091 String Scalar, TRANSLATE or How can I change a character set?
 
01:00
Explains the String Scalar Function TRANSLATE to convert a string to another character set. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 636 cbtinc
Introduction to Dataverse
 
03:54
Welcome to Dataverse. This video will show you how easy it is to acquire, transform and publish your data, in just a handful of steps using Dataverse. See a quick demonstration on: · Acquiring CSV and Excel data · Removing leading and trailing white spaces · Joining data sets · Changing/correcting data types · Publishing data to an Excel output - Download a free copy of Dataverse: http://www.yourdataverse.com/download/ - Join our online Community: http://www.yourdataverse.com/community/
Views: 2717 Data3Sixty Analyze