E-mail Print PDF

MID ()

Синтаксис SQL MID ()

SELECT MID(column_name,start[,length]) FROM table_name

Description
column_name
start
length

Пример SQL MID ()

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger 

1

SELECT MID(City,1,4) as SmallCity FROM Persons

Query Result:

SmallCity
Sand
Sand
Stav

Comments

 
-1 #1 Mahbuba 2011-03-02 13:05 SELECT SUBSTRING (CreditCardAppr ovalCode,1,9) FROM Sales.SalesOrderHeade
displays the first 9 tsyfr. And how to make that first gave me no and 9 poslenie tsyfr? Quote
 
 
0 #2 alex565643 2011-04-26 06:36
SELECT SUBSTRING (CreditCardAppr ovalCode,1,9) FROM Sales.SalesOrderHeade
displays the first 9 tsyfr. And how to make that first gave me no and 9 poslenie tsyfr?

SELECT SUBSTRING(CreditCardAppr ovalCode,Len (CreditCard ppr ovalCode)-9) FROM Sales.SalesOrderHeade r Quote
 
 
0 #3 Inga 2011-05-23 16:33 please help. odnit with MID I sparavilas, but must make it: 2 + 2 letters of the names of the letters + the last 4 numbers from tsyfry Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement


Заказать очистку воды питьевой. ; Скачать qip бесплатно. Вызываемое поллютантами скачать аську на комп 6. Конструктор icq. ; Стильные зонты Christelle Dupont - зонт с логотипом. Магазин садовой и дачной мебели.

© 2009 ageent.ru.