NEWBIE - SQL SUBSTR Function in asp.net

Greetings,

I have a quick question here. Can I use the SQL SUBSTR() function in my SQL
statements in an asp.net page? I am getting an error when I try.

Can anybody point me to a list of functions that are recognized and valid
for SQL statements in asp.net pages? Thank you,

-Dave

Cowboy
Tue Aug 17 07:31:10 CDT 2004

It depends on the database. For SQL Server, you should be fine. If you are
using SQL Server, however, I would encapsulate all logic in stored
procedures. It is easier to maintain (separation of UI and data access),
performs better (precompiled) and can be tested as a separate unit.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"RockNRoll" <daveweber@yahoo.com> wrote in message
news:uckZKOFhEHA.3388@TK2MSFTNGP09.phx.gbl...
> Greetings,
>
> I have a quick question here. Can I use the SQL SUBSTR() function in my
SQL
> statements in an asp.net page? I am getting an error when I try.
>
> Can anybody point me to a list of functions that are recognized and valid
> for SQL statements in asp.net pages? Thank you,
>
> -Dave
>
>

Deepak
Tue Aug 17 07:35:47 CDT 2004

...
I think it should run ....
caz all the fncs. provided by sql runs thro .net

"RockNRoll" <daveweber@yahoo.com> wrote in message
news:uckZKOFhEHA.3388@TK2MSFTNGP09.phx.gbl...
> Greetings,
>
> I have a quick question here. Can I use the SQL SUBSTR() function in my
SQL
> statements in an asp.net page? I am getting an error when I try.
>
> Can anybody point me to a list of functions that are recognized and valid
> for SQL statements in asp.net pages? Thank you,
>
> -Dave
>
>

RockNRoll
Tue Aug 17 09:29:25 CDT 2004

I found out what my problem was. The name of the function is SUBSTRING(),
not SUBSTR().

It works fine now.

"Deepak Arora" <deepak.ssb@idsil.com> wrote in message
news:%23DVVfZFhEHA.3476@tk2msftngp13.phx.gbl...
> ...
> I think it should run ....
> caz all the fncs. provided by sql runs thro .net
>
> "RockNRoll" <daveweber@yahoo.com> wrote in message
> news:uckZKOFhEHA.3388@TK2MSFTNGP09.phx.gbl...
> > Greetings,
> >
> > I have a quick question here. Can I use the SQL SUBSTR() function in my
> SQL
> > statements in an asp.net page? I am getting an error when I try.
> >
> > Can anybody point me to a list of functions that are recognized and
valid
> > for SQL statements in asp.net pages? Thank you,
> >
> > -Dave
> >
> >
>
>