I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Unknown Function: substring?

Unknown Function: substring? in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: Unknown   Function   substring   Unknown Function   Unknown Function substring  
Ritche M
 (Inactive)
Philippines
i don't know why SUBSTRING is an unknown function when i make a select statement in SQL Explorer.

ex: select SUBSTRING("borland" from 4 to 4) from TABLE1

error is either: unknown function or
invalid token "from"

Please help...
 Posted 18 years ago (Thread Starter)
Comment Quote
About Ritche M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #9539, 2 replies
Thread Started 5/6/2003 2:39:00 AM
View Counter=9439
Last Reply Posted 2/20/2017 3:15:04 AM)
Location=Philippines  
Joined=20 years ago   MB Posts=9  
Most Recent Post
Ritche M
 (Inactive)
Philippines
Thank you very much! :)
 Posted 18 years ago (Thread Starter)
Comment Quote
About Ritche M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #9548 (Level 1.1)  Reply to 9539
Thread Started 5/6/2003 5:15:00 PM
View Counter=2
Location=Philippines  
Joined=20 years ago   MB Posts=9  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Well, using SQL Explorer, I get the same problem. I don't think that the InterBase driver for SQL Explorer has the ability to interpret SUBSTRING.



Since we're running IB6 with no UDF's, I also get the error that SUBSTRING is not a recognized function.



What happens when you try to create and execute the stored proc in the InterBase IBConsole's Interactive SQL tool? That's the tool you should be using.
 Posted 18 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #9546 (Level 1.2)  Reply to 9539
Reply Posted 5/6/2003 12:15:00 PM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1266A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9539 Counter
9439
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech