SQL "mid" function?

[ProgressiveJL]

Hey all,

Using CR XI and I'm trying to select the substring of a field. I've tried using MID(field, start, end) but it doesn't seem to be working. Am I using the proper function name? Anyone know where I can find a listing of CR SQL functions?

 

[Durango122]

hi
give ver of crystal and datasource would help and what your trying to do on what field example would help alot


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[dgillz]

Why is the title of your post "SQL mid() function"? Is this not a crystal report formula you are trying to write?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[lbass]

If you are creating a SQL expression or using a command, try one of these (depends upon your datasource/connectivity):

substr(`table`.`string`,3,5)

Or,

{fn substring(`table`.`string`,3,5)}

where the "3" is the starting position and the "5" is the length.

-LB