By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,359 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,359 IT Pros & Developers. It's quick & easy.

views on table having field text

P: 17
Hi

i have a table which has a field having text data type and i want to make a view

on it but convert this text data type in to varchar data type my main purpose.

is to transfer data from sql server to oracle using Heterogeneous Connectivity

and Heterogeneous Connectivity does not transfer fields having data type like

text, ntext.

thanks
Mar 29 '08 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
To covert data types in sql you can use the convert function in your SELECT clause.
For example
Expand|Select|Wrap|Line Numbers
  1. SELECT CONVERT(varchar(10),FieldName1) as FieldName2, 
  2.        CONVERT(int,FieldName2) as FieldName2
  3. FROM TableName
  4.  
Mar 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.