hi , i am using db2 udb v8.1 on NT.
if i have field substr on a varchar type field, what will be the data
type for this field, i check it is char type, why is that?
if i have field substr on a varchar type field, what will be the data
type for this field, i check it is char type, why is that?
If you want a varchar, you can always cast it back:
select varchar(substr(col1,10,5)) from testvar
> if i have field substr on a varchar type field, what will be the data
> type for this field, i check it is char type, why is that?
1. Data Transfer from Long data type to SQL Server Text data type column
Hi All,
Is there any possiblity to transfer Long data type value to SQL
Server?. I'm using DTS package to transfer data. I have to use only SQL
Server Tools or DTS package.
--
Thank you,
With Regards,
A.chellammal
Developer
3. sql data type vs vb data type
5. mssql data types vs JAVA data types
6. set focus in a datagrid cell
7. conversion of ODBC SQL data types to ODBC C data types
8. Joins involving several tables
9. Converting OLEDB data types to VC++ data types
10. Mapping SQL Server Data Types and ADO Data Type Enums
11. Data Type SQL Server7.0 need a non decimal 1 E 19 data type
12. mssql data types vs JAVA data types
13. Disallowed implicit conversion from data type nvarchar to data type money