Truncating VARCHAR text pulled down from query?

[jasonsalas]

What’s the name of the function in SQL Server that lets you truncate the amount of data that’s pulled down in a field? I’m querying a DB table and need to only return at most 15 characters of a large VARCHAR field.

Thanks!

 

[marsh]

Try left()

select left(fieldname,15) from tablename

 

[mrdenny]

Left, substring

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com