Scanftree.com
  • Academic Tutorials
      • Automata
      • Data Structure
      • OS
      • Graph Theory
      • Microprocessor
      • Cryptography
      • Compiler Design
      • Computer Graphics
      • IPv4
      • Parallel Algorithm
  • Programming
      • Tutorials
      • ASP.NET MVC
      • C
      • C++
      • JAVA
      • C#
      • Python
      • Programs
      • C
      • C++
      • JAVA
      • Python
  • Database Concept
    • DBMS
    • SQL
    • SQLite
    • TSQL-MSSQL
  • Preparation
      • Syllabus
      • Gate

      • Interview
      • Technical
      • HR/PI
      • Gk/Aptitude
      • Gk
      • Aptitude
      • MCQ
      • C
      • JAVA
      • Networking
  • Miscellaneous
      • Calculator
      • Health
      • Math
      • Developers
      • Css/Html Maker
      • Cheat Sheets
      • SEO Tools
      • Other
      • Math Formulas
      • IFSC Codes
  •

: Scanftree

tutorial

tsql-mssql

string-function

TSQL-MSSQL
Menu SEE THE INDEX
  • Introduction
  • Pages
    • SQL SERVER BASIC
      • ALIASES
      • AND Condition
      • OR Condition
      • AND and OR
      • BETWEEN Condition
      • Comparison Operators
      • DELETE Statement
      • CREATE TABLE Statement
      • Data Types
      • DELETE TOP Statement
      • EXCEPT Operator
      • LIKE Condition
      • IN Condition
      • NOT Condition
      • ORDER BY Clause
      • EXISTS Condition
      • INSERT Statement
      • INTERSECT Operator
      • GROUP BY Clause
      • HAVING Clause
      • Joins
      • PIVOT Clause
      • Primary Keys
      • UNION ALL Operator
      • IS NULL Condition
      • TRUNCATE TABLE Statement
      • IS NOT NULL Condition
      • Triggers
      • SELECT INTO Statement
      • SELECT TOP Statement
      • UNION Operator
      • Subqueries
    • SQL SERVER ADVANCED
      • Declare Variables
      • Functions
      • Procedures
      • Sequences (Autonumber)
      • Find Users in SQL Server
      • Change a password in SQL Server
      • Comments within SQL
      • DROP USER statement
      • Literals
      • ALTER LOGIN statement
      • ALTER TABLE Statement
      • Check Constraints
      • CREATE LOGIN statement
      • CREATE USER statement
      • DROP LOGIN statement
      • Global Temporary tables
      • Grant/Revoke Privileges
      • Indexes
      • LOCAL TEMPORARY TABLES
      • Unique Constraints
      • VIEW
      • DROP TABLE Statement
    • SQL Server Foreign Keys
      • Disable a foreign key
      • Drop a foreign key
      • Enable a foreign key
      • Foreign Keys
      • Foreign Keys with cascade delete
      • Foreign Keys with set null on delete
    • Loops/Conditionals
      • BREAK Statement
      • CONTINUE Statement
      • FOR LOOP
      • GOTO Statement
      • IF…ELSE Statement
      • WHILE LOOP
    • STRING FUNCTION
      • + Operator
      • CHAR Function
      • CHARINDEX Function
      • CONCAT Function
      • DATALENGTH Function
      • LEFT Function
      • LEN Function
      • LOWER Function
      • LTRIM Function
      • NCHAR Function
      • PATINDEX Function
      • REPLACE Function
      • RIGHT Function
      • RTRIM Function
      • SPACE Function
      • STR Function
      • STUFF Function
      • SUBSTRING Function
      • ASCII Function
    • DATE/TIME FUNCTION
      • YEAR Function
      • MONTH Function
      • CURRENT_TIMESTAMP function
      • DATEADD Function
      • DATEDIFF Function
      • DATENAME Function
      • DATEPART Function
      • DAY Function
      • GETDATE function
      • GETUTCDATE function
    • Conversion Functions
      • CAST Function
      • CONVERT Function
      • TRY_CAST Function
      • TRY_CONVERT
    • Numeric/Math Functions
      • ABS Function
      • AVG Function
      • CEILING Function
      • COUNT Function
      • FLOOR Function
      • MAX Function
      • MIN Function
      • RAND Function
      • ROUND Function
      • SIGN Function
    • Advanced Functions
      • CASE Statement
      • CURRENT_USER function
      • ISNUMERIC Function
      • LEAD Function
      • NULLIF Function
      • SESSION_USER Function
      • SESSIONPROPERTY Function
      • SYSTEM_USER Function
      • USER_NAME Function
      • ISDATE Function
      • COALESCE Function
      • ISNULL Function
      • LAG Function
    • Difference
      • SCOPE_IDENTITY Vs @@IDENTITY
      • Stored Procedure Vs Function
    • Interview Q/A
    • Skip to content

    Aptitude / Reasoning / Interview
    Physical education & sports