No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
You can also add a nonbreaking space between the words, but the colspan adjustment is probably the best... [code]<html> <head> <title>Prefecture History and Facts </title> </head> <body> <h1>Prefecture History / Facts </h1> <hr> <table > <tr> <td >4th Prefecture of New York State, U.S.A. </td> <tr> <td width=25 >Organized in </td> …
[QUOTE=freshfitz;823077]Can I reformat a phone number in SQL manager. I imported a foxpro dbf with the dts wizard and it imported the phone number as (609) 555-1212 I need it to be 6095551212[/QUOTE] Try Nested REPLACE Functions ------------------------------ [code=sql]SELECT REPLACE(REPLACE(REPLACE(REPLACE('(800) 555-1212', '(', ''), ')', ''), ' ', ''), '-', '')[/code] …
The End.