SET ANSI ON
SET EXACT ON
and it will works :o)
>>Thanks for your reply, but.....
>>
>>It's not working, as soon as I put LEN() OR LEFT() in my query it's not resulting anything anymore. This is my query now:
>>
>>m_trim_lidnrfactuur = ALLTRIM(m_lidnrfactuur)
>>m_len_lidnrfactuur = LEN(m_trim_lidnrfactuur)
>>
>>SELECT branche, debnr, factuurnr, factuurdat ;
>> FROM ALLTRIM(m_facturenbestand) ;
>> WHERE LEFT(debnr,m_len_lidnrfactuur) = m_trim_lidnrfactuur AND ;
>> branche = m_branchenrfactuur AND ;
>> INT(VAL(pagina)) = 1 ;
>> INTO TABLE temp4
>>
>>Greetings,
>>Ron
>
>Yes i try
>but this works
>
>
CREATE TABLE yourtable (branche C(10),;
> debnr C(10))
>
>
>INSERT INTO yourtable VALUES ('brance1','5000')
>INSERT INTO yourtable VALUES ('brance2','54')
>INSERT INTO yourtable VALUES ('brance3','5')
>INSERT INTO yourtable VALUES ('brance4','56')
>INSERT INTO yourtable VALUES ('brance5','5')
>INSERT INTO yourtable VALUES ('brance6','59994')
>
>BROWSE NORMAL
>m_facturenbestand = 'yourtable'
>m_lidnrfactuur = '5'
>m_trim_lidnrfactuur = ALLTRIM(m_lidnrfactuur)
>
>SELECT branche, debnr ;
>FROM (m_facturenbestand);
>WHERE debnr == m_trim_lidnrfactuur
>
>HTH
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.