>>>
>>>CREATE VIEW pv1_rate AS;
>>> SELECT * ;
>>> FROM rate ;
>>> WHERE code = ?m.code
>>>
>>>m.code = SUBS(callId,1,6)
>>>USE pv1_rate
>>>

OPEN your database by issuing...

OPEN DATABASE MyData

Then run the code exactly as it is above/below...

CREATE VIEW pv1_rate AS;
SELECT *;
FROM yourratetable;
WHERE yourcodeid = ? m.code

then assign a code value to m.code like...

m.code = '175010'

then use pv1_rate like...

USE pv1_rate

The result will only contain entries that have a code of '175010'


Wayne