"Ron" <ron@razorvision.net> wrote in message
news:bdq9om$7nh@library2.airnews.net...
> How can I select a certain number of characters from a string, without
> selecting the whole string?
>
> For example, I want the first 50 characters of a 500 character string in
my
> database. What would the SQL command to do this look like?
>
> Thanks,
>
> Ron
>
>

"Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
news:OjeyQA1PDHA.3768@tk2msftngp13.phx.gbl...
> This is not the best forum for a SQL question, but I believe I have your
> answer anyway.
> Use the Left() SQL function. You could also use the SubString method.
> Here's more info:
>
http://www.experts-exchange.com/Developer/Databases/Microsoft_SQL_Server/Q_20639372.html
>
> --
> I hope this helps,
> Steve C. Orr, MCSD
> http://Steve.Orr.net
>
>
> "Ron" <ron@razorvision.net> wrote in message
> news:bdq9om$7nh@library2.airnews.net...
> > How can I select a certain number of characters from a string, without
> > selecting the whole string?
> >
> > For example, I want the first 50 characters of a 500 character string in
> my
> > database. What would the SQL command to do this look like?
> >
> > Thanks,
> >
> > Ron
> >
> >
>
>