>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.