Creating view and changing data type

[doc1000101]

Pervasive Version 11.31
Working on a crystal report and I need to link two tables, however the data types on one of the fields is different. I think the easiest way for me to deal with this is to create a new view and change the data type.

For simplicity we'll say:
Table A, field 1 is integer
Table B field 1 is Char.

I want to change table A field 1 to a char in the view.

Is this possible?

 

[mirtheil]

You can use either [tt]CAST[/tt] or [tt]CONVERT[/tt] to convert results.
For example:
[tt]SELECT CAST(field1 as INTEGER) FROM TableA[/tt]
[tt]SELECT CONVERT(field1, SQL_INTEGER) FROM TableA[/tt]

Full documentation is at [URL unfurl="true"]http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/scalarfunc.05.7.html[/url].

Mirtheil

http://www.mirtheil.com