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 |
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2006-08-04 : 10:38:27
|
1A apple street11 apple street1B apple streeti want to select only the first address. how do i do it? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-04 : 10:39:16
|
[code]select top 1 addressfrom addressesorder by address[/code] KH |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2006-08-04 : 10:44:05
|
thanks but, i dont want it that way.how do i only select 1A and 1B addresses? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-04 : 10:48:20
|
then define what do you mean by "first address" KH |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-04 : 11:26:25
|
Where Address in ('All your Addresses')MadhivananFailing to plan is Planning to fail |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2006-08-04 : 13:03:28
|
1a111bhow can i select only the rows that has alpha numeric values? likerows----1a1b |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-04 : 13:42:18
|
select * from table where address like '[0-9][a-z]%'Peter LarssonHelsingborg, Sweden |
|
|
X002548
Not Just a Number
15586 Posts |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|