I have a table with 30+ fields and I want to quickly narrow my selection down to all fields where column name start with 'Flag'. select * Like Flag% from Table1

I am converting a database that was made in the 80's and it seems that the date for some tables is stored as characters. There are 2 columns of data. The first column has data formatted like this: ...

I have the following tables: Employees ------------- ClockNo int CostCentre varchar Department int and Departments ------------- DepartmentCode int CostCentreCode varchar Parent int Departmen...

I'm using Pervasive 10 with PCC (Pervasive Control Center) and I need to export a lot of results (over 100 000) to a TXT file.I know it's possible "Execute in Text" but this feature does not work f...

I am connecting to a Pervasive SQL database which splits some data over two fields. DOUBLE fields are actually split into fieldName_1 and fieldName_2 where _1 is a 2 byte int and _2 is a 4 byte int...