Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in a sql expression of cursoradapter
Message
 
 
To
28/03/2010 11:18:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01457654
Message ID:
01457681
Views:
30
>>>>
>>>> TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>>>>			SELECT HDBK, Hid , HDOCNO, HAMOUNT,  STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
>>>>			STR(Createdon) AS 'createdon' , hremint  FROM <<.TABLES>>
>>>>WHERE HDBK LIKE '[F][14C]'
>>>>		      ENDTEXT
>>>>
>>>
>>>Assuming that this syntax is supported, you may still need the % %
>>
>>Why? I want the first character to be F and the next to be 1,4 or C.
>
>
>I understand - but since we don't know what that field may contain, the % may be necessary
>
>It may contain something like
>
>C1/F4/P7
>
>
>
>In any case - there's not enough information to judge

Right - I assumed that we wanted to extract records with F1 or F4 or FC for the HdBk by looking at the results provided in the screenshot.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform