Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-12 : 10:44:06
|
| Robert writes "1) I have a column, in a SQL Server 7 table, of file names with their extensions. I would like to execute a sql script that would remove the extensions (.pdf) from the file names. 2) I would also like to remove the leading space in column of First names. I don't know how they got there. However, some of the records have a leading space.Can you help me write these scripts? Thanks in advance.Bob R." |
|
|
|
|
|
remove the last 4 characters in a record string