Substring dont get all chars?

Dev Shed Forums Sponsor:

June 13th, 2012, 03:55 AM

big200

Registered User

Join Date: Jun 2012

Posts: 2

Time spent in forums: 1 h 43 m 26 sec
Reputation Power: 0

Substring dont get all chars?

Hello I have problem with getting proper data from database.
1) I have query :

Code:

select Nazwa, IDTOWR, ODPLT from leki l , TOWR t
where t.id=l.IDTOWR

and it returns
URL
http://i47.tinypic.com/2mc5zqt.jpg
2) When I make

Code:

select Nazwa, IDTOWR, ODPLT from leki l , TOWR t
where t.id=l.IDTOWR and upper(SUBSTRING(ODPLT FROM 72 FOR 72)) = 'X'

i get
URL
http://i48.tinypic.com/2jfonb.jpg
As you see I don't get items with idtowr 26, 27... but they got x on 72 position. I'm using Firebird 2.5. Plz tell me what I'm doing wrong. Thank you in advance for you help and sorry for my English.

Last edited by big200 : June 13th, 2012 at 03:58 AM. Reason: No images

June 13th, 2012, 08:55 AM

tsteinmaurer

Contributing User

Join Date: Oct 2010

Posts: 34

Time spent in forums: 5 h 2 m 19 sec
Reputation Power: 3

The FOR part defines the number of characters you want to read and not the end position in the string, so it should be something like that:

Code:

SUBSTRING(ODPLT FROM 72 FOR 1)

See also:
http://www.firebirdsql.org/refdocs/...-substring.html

Hope this helps.

Thomas

June 13th, 2012, 09:09 AM

big200

Registered User

Join Date: Jun 2012

Posts: 2

Time spent in forums: 1 h 43 m 26 sec
Reputation Power: 0

Quote:

Originally Posted by tsteinmaurer

The FOR part defines the number of characters you want to read and not the end position in the string, so it should be something like that:

Code:

SUBSTRING(ODPLT FROM 72 FOR 1)

See also:
http://www.firebirdsql.org/refdocs/langrefupd15-substring.html

Hope this helps.

Thomas

THX very much I got some bad translation in my program now all works fine.

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Substring dont get all chars?

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump