Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sybase ASCII equivalent function

Status
Not open for further replies.
tdatauser

tdatauser

Technical User
Feb 17, 2003
2
US
Hi

Is there any sybase ASCII equivalent function in Teradata ?

Thanks in advance
 
Sort by date Sort by votes
No, Teradata is lacking of string functions :-(
You'll have to wait for R5.1 introducing User Defined Functions.

There's a CHAR2HEXINT returning a string of hex-values. e.g.

Char2HexInt('bla') -> '626C61'

Dieter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ianbrown76
  • Locked
  • Question
Find ASCII code of characters in columns
Replies
0
Views
127
ianbrown76
ianbrown76
terrordata2
  • Locked
  • Question
Teradata Equivalent to ORACLE UNPIVOT Command
Replies
0
Views
43
terrordata2
terrordata2
sajisher
  • Locked
  • Question
What is equivalent of oracle (+)= in Teradata
Replies
2
Views
56
sajisher
sajisher
OceanDolphin
  • Locked
  • Question
function
Replies
0
Views
22
OceanDolphin
OceanDolphin
kwons9
  • Locked
  • Question
Can any date function solve this problem?
Replies
1
Views
49
al1024
al1024

Part and Inventory Search

Sponsor

Back
Top