Simple character questions - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Simple character questions

Author

Topic

abarsami
Yak Posting Veteran

68 Posts

Posted - 2001-07-30 : 15:29:47

Let's say I have this in my database:

tm3~~3c~~

I want to say select the first 3 characters.
Somehow select all the characters before the 1st "~~"

Is there a way to say that?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources