Webinar By Academy4Code.com – How to Handle Concurrency in SQL Server?

SQL In-built Functions Part-3

SQL Functions | Academy4Code.com
  • What is SQL NCHAR Function?

NCHAR function returns the Unicode character based on the number_code in the Unicode standard.

Syntax: NCHAR(Number code)


NCHAR | SQL Function - Academy4Code
NCHAR | SQL Function – Academy4Code

The above query returns the Z character which code is 90 in ASCII.

  • What is SQL PATINDEX Function?

The PATINDEX functions

SQL In-built Functions Part-2

SQL Functions | Academy4Code.com
  • What is SQL Left() Function?

LEFT function allows you to extract a substring from a string, starting from the left-most character.

In simple word left function will be return the string started from left side an Syntax or a string,

Syntax: LEFT (String, Number of characters)


Left SQL Function- Academy4Code
Left SQL Function-
Page 3 of 712345...Last »