Extracting only certain number of characters from a fiel

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Extracting only certain number of characters from a fiel

Message

28/02/2010 03:32:04

Borislav Borissov
Microcomplex
Sofia, Bulgarie

28/02/2010 02:40:53

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Extracting only certain number of characters from a fiel

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01451580

Message ID:

01451582

Vues:

This message has been marked as the solution to the initial question of the thread.

>In a SQL select, I need to only extract a certain number of characters in a field. Lets say I have a title field of 100 characters. I would like to only extract the first 64 characters. What would be the proper syntax to use for that?

SELECT LEFT(FieldName, 64) AS ...

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Répondre

Fil

Voir

Click here to load this message in the networking platform