Message
From
03/06/2008 08:25:54
Sergey Berezniker
New York
,
United States
To
03/06/2008 07:57:49
Tc Holzer
Isle of Man
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re:
Find a string within a column in sqlserver
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01321126
Message ID:
01321255
Views:
15
Would this work for you
SELECT
*
FROM
Mytable
WHERE
REPLACE
(Mycolumn,
SPACE
(
1
),
SPACE
(
0
))
LIKE
'%;ABC'
?
>Perfect Stefan, thanks!
>
--sb--
Previous
Next
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only