SELECT MID(Field1,1,5) FROM tbl_Table1
SELECT SUBSTRING(Field1,1,5) FROM tbl_Table1
SELECT LEFT(Field1, LEN(Field1) / 2) FROM tbl_Table1
SELECT SUBSTRING(Field1,1,len(Field1)/2) FROM tbl_Table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)