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!

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

Strtran Function In SQL Server

Status
Not open for further replies.

edrossi

Programmer
Joined
Jan 24, 2002
Messages
42
Location
US
What is the equivelant of the strtran command in Foxpro in SQL Server?
 
there is no equivelant.

there is SUBSTRING, RIGHT, RTRIM, LTRIM, STR, ASCII, CHAR

try combining these with concatanation to get what you want Attitude is Everything
 
edrossi;

Use REPLACE. The syntax is the same.

Ed Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.
smallbug.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top