#DateForumTypeThreadPost
312 Nov 2008 @ 06:03 PSTAnalyticsTopicBad character in format or dataHi,I have two tables, say Table1 and Table 2. Both the tables have the same column, Say 'Phone number'.But the Datatype of Phone number field in Table1 is char(27) and Table2 is decimal(10).Now i a...
211 Nov 2008 @ 05:47 PSTAnalyticsReplyRemove '-' from a columnHi Adeel,Thanks for your reply. But the record i have given was just an example. The column is a phone number field and it can have '-' in any position. It is not predictive. Hence i want to remove...
111 Nov 2008 @ 04:56 PSTAnalyticsTopicRemove '-' from a columnI have a phone number column which has records like '111-222-333' . I need to remove the '-' from each phone number. Any suggestions?