>>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

or
Thanks Boris

SET ANSI ON
SET EXACT ON

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','54')
INSERT INTO yourtable VALUES  ('brance6','59994')

BROWSE NORMAL
m_facturenbestand = 'yourtable'
m_lidnrfactuur = '54'

SELECT branche, debnr ;
FROM (m_facturenbestand);
WHERE debnr = m_lidnrfactuur