Selecting Certain Number of Characters from Table -- Simple SQL Question

[Ron]

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]

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:
[url]http://www.experts-exchange.com/Developer/Databases/Microsoft_SQL_Server/Q_20639372.html[/url]

--
I hope this helps,
Steve C. Orr, MCSD
[url]http://Steve.Orr.net[/url]


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

[Ron]

Thanks for your help,

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

[url]http://www.experts-exchange.com/Developer/Databases/Microsoft_SQL_Server/Q_20639372.html[/url]

>
> --
> I hope this helps,
> Steve C. Orr, MCSD
> [url]http://Steve.Orr.net[/url]
>
>
> "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
> >
> >

>
>