Sql

Select First two Character in selected Field with Left(string,Number of Char in int)

SELECT LEFT(FName, 2) AS FirstName FROM dbo.NameMaster

SELECT * FROM <Table> WHERE LEFT(<columnName>,1) = "s";

PREVIOUS	NEXT

Code Example
Sql :: sql show all users
Sql :: mysql change auto_increment start value
Sql :: oracle trigger after connect
Sql :: mysql trim
Sql :: sql duplicate rows
Sql :: mysql limit rows
Sql :: oracle sql date get month
Sql :: postgresql create user
Sql :: import large .sql files into lampp
Sql :: create user sql server
Sql :: copying query result to excel
Sql :: backup a table in sql
Sql :: mysql alter table add column first
Sql :: sql drop default
Sql :: drop df constraint sql server
Sql :: postgresql insert column
Sql :: rename table column postgresql
Sql :: how to drop a table in mysql
Sql :: sql waitfor
Sql :: n highest salary in sql
Sql :: oracle first row
Sql :: show table postgres command
Sql :: oracle case
Sql :: show all event schedular on mysql
Sql :: update table from another table
Sql :: spring data.sql table not found
Sql :: sql convert float to string
Sql :: IS NOT NULL statement
Sql :: mysql update two tables at once
Sql :: sql now