NEWBIE - SQL SUBSTR Function in asp.net

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

RockNRoll

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
 
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!
************************************************
 
I found out what my problem was. The name of the function is SUBSTRING(),
not SUBSTR().

It works fine now.
 
Back
Top